Auto Create a TOC.

thelton

New Member
Joined
Sep 5, 2002
Messages
29
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
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,118,674
Messages
5,573,597
Members
412,537
Latest member
Mohamed_5966
Top