View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default TABLE OF CONTENTS

David McRitchie has a macro on his site for building a table of contents
automatically, with hyperlnks to every sheet. Here is the link:

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

Hope this helps,

Hutch

"BG" wrote:

I am looking to see if there are any "Table of Content" or "Price List"
Templates. I currently have a workbook with 3 worksheets (List of items,
Index, Table of Contents). I'm looking for something where I can link cells
in one worksheet to jump to cells of another worksheet. I attempted to use
links, linked several cells, and then decided to change the name of the
worksheet I had linked to. Is there a quick fix for this? any suggestions
welcome.