Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2014, 04:53 PM
retiredstuart retiredstuart is offline I need an index file containing the names of all the worksheets in a workbook. Windows 7 64bit I need an index file containing the names of all the worksheets in a workbook. Office 2007
Novice
I need an index file containing the names of all the worksheets in a workbook.
 
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
  #2  
Old 09-11-2014, 09:59 PM
gebobs gebobs is offline I need an index file containing the names of all the worksheets in a workbook. Windows 7 64bit I need an index file containing the names of all the worksheets in a workbook. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 09-12-2014, 01:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I need an index file containing the names of all the worksheets in a workbook. Windows 7 64bit I need an index file containing the names of all the worksheets in a workbook. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps this page will help ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 09-12-2014, 06:26 AM
retiredstuart retiredstuart is offline I need an index file containing the names of all the worksheets in a workbook. Windows 7 64bit I need an index file containing the names of all the worksheets in a workbook. Office 2007
Novice
I need an index file containing the names of all the worksheets in a workbook.
 
Join Date: Sep 2014
Location: north Texas
Posts: 2
retiredstuart is on a distinguished road
Default

To Pecoflyer: That's exactly what I needed. Thanks so much for telling me how to find it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need an index file containing the names of all the worksheets in a workbook. Summing data from multiple worksheets in a workbook and placing into another worksheet safrac Excel 17 10-04-2022 12:21 PM
I need an index file containing the names of all the worksheets in a workbook. Have to rename file every time to save workbook intelli Excel 3 03-27-2014 11:53 PM
I need an index file containing the names of all the worksheets in a workbook. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft