I want to add a contents page to a workbook. When I group the worksheets to
print I want the page number of each sheet to be inserted automatically in a
cell in the contents page alongside the sheet title. At the present I am
inserting the page number manually. Can I do it?

Each worksheet can have multiple pages to print...
So I don't understand what page number would be entered
next to the sheet name.
In any case, you may want to give the free Excel add-in "Excel Extras" a try.
It creates a Table of Contents sheet that lists every sheet in the workbook.
Each sheet name is hyperlinked to the sheet. Next to the sheet name is the
number of printable pages for that sheet.
If that interests you it can be downloaded from...
http://www.realezsites.com/bus/primitivesoftware
It does other stuff too...sorting sheets and setting / reading print areas
and more.
--
Jim Cone
San Francisco, USA


"pkeegs"

wrote in message
I want to add a contents page to a workbook. When I group the worksheets to
print I want the page number of each sheet to be inserted automatically in a
cell in the contents page alongside the sheet title. At the present I am
inserting the page number manually. Can I do it?

Thanks for the reply Jim, I will try the link.

My workbook consists of about 20 sheets, most of which are doing various
calculations. There are about 8 sheets which produce a report (literally a
book), each one of those sheets may or may not have more than one printed
page. At the front of the book I have a contents page which enables the
reader to move straight to the individual report required. By grouping the
report pages and using page numbers in the footer the book has a continuous
numbering throughout. I want to automatically place the first page of each
report into the contents. Not every report will have the same sheets or pages
printed from each sheet.

Cheers - Peter

"Jim Cone" wrote:

Each worksheet can have multiple pages to print...
So I don't understand what page number would be entered
next to the sheet name.
In any case, you may want to give the free Excel add-in "Excel Extras" a try.
It creates a Table of Contents sheet that lists every sheet in the workbook.
Each sheet name is hyperlinked to the sheet. Next to the sheet name is the
number of printable pages for that sheet.
If that interests you it can be downloaded from...
http://www.realezsites.com/bus/primitivesoftware
It does other stuff too...sorting sheets and setting / reading print areas
and more.
--
Jim Cone
San Francisco, USA


"pkeegs"

wrote in message
I want to add a contents page to a workbook. When I group the worksheets to
print I want the page number of each sheet to be inserted automatically in a
cell in the contents page alongside the sheet title. At the present I am
inserting the page number manually. Can I do it?