| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List worksheet names in a seperate sheet
Oh Wise Ones
HR has a workbook that they add worksheets to and manually name them, beginning withe either "AC" or "NM" (accident or near miss). I have a sheet named "Control" that has code to count the number of worksheet by prefix. Could I have a dynamic range on that sheet that lists the "names" of the worksheets in a column? And if its not too much more difficult, dynamically link to the specified sheet? Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List worksheet names in a seperate sheet
Thanks Jim! XL Extras works pretty slick.
Note my new post on automating worksheet indexing. Mike "Jim Cone" wrote: A couple of options in this post... http://tinyurl.com/2y2k56 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Mike K" wrote in message Oh Wise Ones HR has a workbook that they add worksheets to and manually name them, beginning withe either "AC" or "NM" (accident or near miss). I have a sheet named "Control" that has code to count the number of worksheet by prefix. Could I have a dynamic range on that sheet that lists the "names" of the worksheets in a column? And if its not too much more difficult, dynamically link to the specified sheet? Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move new item on list to seperate sheet | Excel Discussion (Misc queries) | |||
| How- seperate a combined list by filtering out first list of names | Excel Worksheet Functions | |||
| Creating seperate sheet lists from larger list | Excel Discussion (Misc queries) | |||
| List Worksheets in seperate worksheet | Excel Programming | |||
| Macro to list info on seperate worksheet | Excel Programming | |||
Linear Mode
