-
TABLE OF CONTENTS NOT USING TABS
I want to create a table of contents based not on the tab names, but instead the data in a specific cell (B1 - which is the same for all the sheets) as it contains a more detailed description of the sheet. The tab names are abbreviations which would be meaningless to most users.
So far I have found everything I need to create this table of contents except how to loop through all the sheets and get the description in B1 into the TOC.
Any advice appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules