| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating and Index with worksheet names
I have a workbook with about 40 worksheets, I would like to create 1
worksheet that woud provide the user with a list of all the worksheets, and then be able to click on that name and have it take them to that worksheet. sort of a control panel that they can go to to find the sheet they are looking for instead of going through all the tabs. Any easy thought on how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating and Index with worksheet names
See
http://www.mvps.org/dmcritchie/excel/buildtoc.htm In article , "JackR" wrote: I have a workbook with about 40 worksheets, I would like to create 1 worksheet that woud provide the user with a list of all the worksheets, and then be able to click on that name and have it take them to that worksheet. sort of a control panel that they can go to to find the sheet they are looking for instead of going through all the tabs. Any easy thought on how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Buttons to navigate and drop down menus | New Users to Excel | |||
| Creating A Search Database..Need Help | Excel Discussion (Misc queries) | |||
| creating a search model | Excel Worksheet Functions | |||
| setting a tab index within excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
