Cactusfunk
New Member
- Joined
- Apr 7, 2002
- Messages
- 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
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