|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
Recipes? As in cooking recipes?
Certainly you could have an index sheet with hyperlinks to the worksheets. Or compact it a bit by putting them on separate tabs of a single worksheet. But if they are cooking recipes, why use Excel. Excel is for data analysis. Word is more appropriate for written documents.* If you put them all in an Word document, you can simply apply the Heading 1 style to the title of each and Word can generate a table of contents automatically. * True story. I had an engineer once email a resume to me as an Excel file. Sorry, if you don't know the basic tools, how can i expect you to understand your job. |
#4
|
|||
|
|||
To Pecoflyer: That's exactly what I needed. Thanks so much for telling me how to find it.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
Have to rename file every time to save workbook | intelli | Excel | 3 | 03-27-2014 11:53 PM |
Workbook data Names in VBA are string only? | BobBridges | Excel Programming | 7 | 01-29-2014 09:02 AM |
creating an index of names etc | H28Sailor | Word | 2 | 07-26-2013 10:50 PM |
Two Different Names in the Same File | kathy carson | Outlook | 0 | 02-14-2006 01:02 PM |