Table of Contents based on worksheet names???
Table of Contents based on worksheet names???
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Table of Contents based on worksheet names???

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    Is it possible to generate a "table of contents" automatically based on the names of the non-hidden worksheets at the bottom of a workbook?

    So if I had sheets 1-3 and 5 visible I would get a list on the first sheet like..

    Master
    DS0
    DS1
    BDFB

    and if I made visible sheet 4 the list work automatically update to say..

    Master
    DS0
    DS1
    DS3
    BDFB

    Also if I had multiple sheets named the same thing it would sum the number of sheets..

    Like

    Master 1
    DS0 12
    DS1 8
    DS3 10
    BDFB 3

    And if I change the order of sheets the table of contents would be up dated

    Master 1
    BDFB 3
    DS3 10
    DS0 12
    DS1 8

    The table of contents code would need to work in such a way that it would not use absolute paths as the workbook can be as small as 10 worksheets or over 100.

    Thanks for reading

    Jason

    Oh and if this is beyond the scope of excel, please hit me over the head with a little reality

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try http://asap-utilities.com/
    It has a lot of useful utilities including what you want.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com