How to Create filtered drop down list in Excel 2003

[Bardman1123]

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 row in the query revealed.

Ideally, Column A would have a drop down list also

Column C and on would then use Vlookup on column B to pull their data from the query.

Any ideas? My only thought so far is a dynamic range for each selection in column A, and have column B's dropdown reference that range. Do I need to sort the query by group to make this happen?

 

[Bardman1123]

oops bad link... try this one

 

[remeng]

Ok I am really confused as to what you actually did. It is possible to link an acces database and excel just by using the wizards provided. I would just link the access database to an excel file, or use the filters in access to produce what you are looking for. I think that you are making this way to complicated. Then again I might have missed your target.

 

[Bardman1123]

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 column B will only show recipes from group selected in column A.

 

[xlbo]

Here:

http://www.contextures.com/xlDataVal13.html

has a pretty good example



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Bardman1123]

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.