multiple drop down lists
 

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.

There are instructions here for dependent data validation lists:

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


jason n z wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html