Progressive Filtering

[Doc203]

I am working in a rather large Vehicle database with 44k rows. It looks something like:

Year-----Make-----Model-----Weight
1972----Chevy----Impala-----3800
2005----Chevy----Impala-----2900
1972----Ford-------F150-----4000
1997----Chevy----Impala-----3800


What I want to do is a combo box with a data validation list that the user chooses in order, which progressively shrinks the next choice.

IE - If you choose year 1972, it narrows the choices of the "Make" Column (Similar to auto filter). You then choose the Make column, which in turn shortens the model list. Then when you finally choose a model, which would be the final choice.

After choosing the model, the weight is the final product.

Any ideas?

Thanks,

Jim

 

[Doc203]

Also, there are several duplicate instances of "year" and when I use data validation, I would like to only reveal one instance of each year for the user to pick from.