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
Thanks again.
Trent