Thread: Create auto updating data validation list from all worksheet names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Create auto updating data validation list from all worksheet names
Define a dynamic range and give it a name then use the name as your source in DV

=MyList

See Debra Dalgleish's site for creating and naming dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

On Mon, 10 Dec 2007 10:59:03 -0800, fryguy
wrote:

I am stumped. I would like to create a list from all the worksheet names in
a workbook. I have created these lists before by typing the names into a
list and using data validation to create the list.

Can the list be automatically updated when a new sheet is added or one is
deleted without manually changing the list each time?

Reply With QuoteReply With Quote