See Debra Dalgleish's site for Data Validation dependent lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 15:58:02 -0700, UTResearchAnalyst
wrote:

I am making an energy efficiency calculator for a fleet of vehicles. For
each year, make and model, I have specific information as to MPG, CO2, and
Air Pollution Score. I am trying to make a drop down list to choose year,
then based on year, makes that were purchased that year, then based on makes,
the models bought in that year of that make.

Each vehicle will have a row with columns: Year, Make, Model, MPG, Air
Quality. MPG and Air Quality be hard numbers, not selected in the drop-down.

Thank you for your help!