View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Using more than one list in a drop-down

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?