Table of Contents based on worksheet names???

Cactusfunk · Apr 8th, 2002, 01:59 PM

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

Al Chara · Apr 8th, 2002, 02:02 PM

Try http://asap-utilities.com/
It has a lot of useful utilities including what you want.

Apr 8th, 2002, 02:02 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try http://asap-utilities.com/ It has a lot of useful utilities including what you want. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 01:59 PM	#1
Cactusfunk 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