[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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Des_2001" wrote in message
...
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?

[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

On Wed, 27 May 2009 06:53:02 -0700, Des_2001
wrote:

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?