Restarting page numbers part way through report

Hudco

Board Regular
Joined
Jan 4, 2006
Messages
127
Office Version
  1. 365
Hi folks,
We have a report which consists of 10 sheets. Several of the sheets may vary in the number of pages that print. For example sheet 4 in the series may print 1 or up to 5 pages (varies with each report). For example:

Sheet 1 - 1 page
Sheet 2 - 1 page
Sheet 3 - 1 or 2 pages
Sheet 4 - 1 or 2 pages
Sheet 5 - 1 to 4 pages
Sheet 6 - 1 page
External pages (6) inserted after print run
Sheet 7 - 1 or 6 pages
Sheet 8 - 1 page
Sheet 9 - 1 page
Sheet 10 - 1 or 8 pages

The problem I have is that after printing 6 pages from an external source are collated into the printed product. These external pages are inserted after sheet 5. What I want to try and do is have sheet 6 start at the last page number on sheet 5 + 6. That is, sheets 1 - 5 may be 8 pages. Add in the external 6 pages and so sheet 6 needs to start at page 15.

It would be really good if the total number of pages could also stay aligned (e.g. page 15 of 25)

I have tried resetting the numbers but looking for a way to automate.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,223,886
Messages
6,175,189
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top