Using more than one list in a drop-down

[Des_2001]

I created a drop-down menu from a list of names, but now I need to add
another list of names as well. Because of the grouping, I can't just add the
names to the original list. Is there any way to use more than one list in a
drop down menu?

 

[Don Guillett]

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

 

[Gord Dibben]

Why can't you add the names to the original list?

Do you want the second list dependent upon what is selected in the first
list?

See Debra's site for creating those.

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


Gord Dibben MS Excel MVP