Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using sheet name of workbooks
I have an Excel 2003 workbook which contains a master sheet that needs
to retrieve and use the names of the other sheets contained in the workbook. For example, the master sheet ("Instructions") would show in cells A1 - A5 the names of the five other sheets in the workbook that might be called "Test1", "Test2", "Test3", "Test4" and "Test5". Once the master sheet has a usable reference to the other sheet names, any time one of those names changed (or additional sheets added) the master sheet would automatically get updated. Is this possible either using a sheet reference formula or VBA (preferably formula)? Ideally, the master sheet would reference the other sheets as a Hyperlink cell so clicking on any of the individual names would take the user directly to the appropriate sheet! Any ideas how this can be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculations across sheet and other workbooks | Excel Discussion (Misc queries) | |||
Mass add of a sheet to multiple workbooks | Excel Discussion (Misc queries) | |||
Can I consolidate one work sheet from several workbooks? A few oth | Excel Discussion (Misc queries) | |||
One Sheet referres to many workbooks | Excel Worksheet Functions | |||
Multiple Sheet workbooks | Excel Worksheet Functions |