Max,

Thank you. How do I then use that pull down to limit the number of entries
in the 2nd pulldown to limit it to "Camaro's?

"Max" wrote:

"Donna" wrote:
How can I use pull down lists to filter data. For instance I have a
spreadsheet of 100 different cars of various makes/models. I want to use
the first pull down menu to filter out all of the Chevrolets. The next pull
down will show the results of the first pull down. where I can select one.
Is this possible?

Assume the car make descriptions are housed in col B,
label in B1, data from row2 down

Select the entire table, then
Click Data Filter Autofilter
Select "Custom" from the autofilter dropdown list in B1
Under "Show rows where",
Select "contains", then type in the box next to it: Chevrolet
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---