multiple drop down lists

[jason n z]

i have created a drop down list. i am looking to create a sub list (or maybe
2) of this. eg when the first item is selected from drop down list one, a
second subset become availiable.

as an examlpe if the first list was cars and the drop down menu gave
manufacturers names, the second would give models.

 

[Debra Dalgleish]

There are instructions here for dependent data validation lists:

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