Create automatic table of contents using worksheet labels
 

I have a huge workbook. I would like to have a table of contents that uses
the worksheet label as the reference point. This way, I can quickly create
an overview of all worksheets, with automatic hyperlinks to each one.
can anyone help?
thanks

What is the worksheet label? Is it the worksheet name?

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


will do what you want


Regards,

Peo Sjoblom
"Alexandre" wrote:

I have a huge workbook. I would like to have a table of contents that uses
the worksheet label as the reference point. This way, I can quickly create
an overview of all worksheets, with automatic hyperlinks to each one.
can anyone help?
thanks

Take a look he

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


In article ,
Alexandre wrote:

I have a huge workbook. I would like to have a table of contents that uses
the worksheet label as the reference point. This way, I can quickly create
an overview of all worksheets, with automatic hyperlinks to each one.
can anyone help?
thanks