| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create auto updating data validation list from all worksheet names
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list (Word) of the names on Excel worksheet tabs | Excel Worksheet Functions | |||
| Create a list in one worksheet of the other worksheets' names | Excel Worksheet Functions | |||
| create a list of worksheet names (from a single folder, or open files) | Excel Discussion (Misc queries) | |||
| Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
| How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Threaded Mode
