Phil Ventresca said:
How do I create an index or TOC for worksheets in an excel workbook?
One good, easy way is Jim Cone's fine, free product (his XL Extras add-in)
available at his page:
http://www.realezsites.com/bus/primitivesoftware/products.php
Scroll right down to the bottom of the page for the download link:
XL Extras - release 1.21 ... Download
A collection of additional features including...
**create table of contents with hyperlinks to each sheet
Jim's add-in will do exactly what you're looking for (and much more ..)
After installing, just click Insert > Table of Contents (new menu item),
then lounge back and watch Jim's magic go to work!
