View Single Post
 
Old 09-11-2014, 04:53 PM
retiredstuart retiredstuart is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2014
Location: north Texas
Posts: 2
retiredstuart is on a distinguished road
Default I need an index file containing the names of all the worksheets in a workbook.

I keep an Excel workbook for recipes..... a lot of recipes; each worksheet is for a different recipe. Is there a way to keep some kind of index worksheet for the names of all the different worksheets? Maybe if I could go to the index file, create a new name and a new worksheet would be created with that name? The alternative is to create a new worksheet and manually enter the name of each worksheet, then scroll through the workbook to find the sheet I want. Ideally I could go to the index, click on it and go to that worksheet. Possible?
Reply With Quote