Table of contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a large spreadsheet with numerous worksheets and would like to be able to insert a table of contents at the front of the report. Each heading in the table of contents would be the worksheet name. Is there any way of doing this?
I know I can put a table of contents page in the report and fill in the page numbers by manually doing a print preview and then filling in each page number manually. Any help would be greatly appreciated.
 
Dave,

Check out

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


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dave said:
I have created a large spreadsheet with numerous worksheets and would like
Click to expand...
to be able to insert a table of contents at the front of the report. Each
heading in the table of contents would be the worksheet name. Is there any
way of doing this?
I know I can put a table of contents page in the report and fill in the
Click to expand...
page numbers by manually doing a print preview and then filling in each page
number manually. Any help would be greatly appreciated.
 
Back
Top