EXCELLENT!!!
Thank you!!
I was kind of thinking I needed to sort the data table with the first dropdown criteria, but didn't know how to segregate the ranges.
this is exactly what I needed.
End users of the excel file won't be able to access the Acess database directly (network drive they don't have rights for).
I'm actually planning on hiding the data query tab before I'm done.
User will first choose recipe group (breakfast, deli, etc) in column A, then the drop down in...
I'm trying to create a "filtered" drop down list in Excel and am getting stuck.
Looking at the attached file, the Data tab contains data queried from an Access database.
In the input tab, I want to use column A (group) to make the dropdown list in column B (recipe) shorter than having every...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.