![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 1
|
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 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
__________________
Kind regards, Al Chara |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|