Auto Create a TOC.

[thelton]

I have a large workbook and on the first page is a Table of Contents that hyperlinks to the sheets within the workbook. Is there a way to auto create the text on the TOC sheet every time a new sheet is added, just the text would be a great help even if I have to go back and make it a hyperlink. I didn't know if there was a field that might do this,like the {date} and so on.
Thanks again.

Trent

 

[Richie(UK)]

Hi Trent,

This link may be useful:

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

HTH