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
> ---