Different Page Numbers In Worksheet w/Page Breaks

[UT]

Hi,

I have one worksheet with vertical and horizontal page breaks. I am trying
to insert different page numbers in the worksheet.

For example Page 1 to Page 3 should have page number 1, 2, 3.
Page 4 to Page 6 should again new page numbers - 1,2,3 and so on

How can do this?

Second issue is that I would like to have a different header for these pages
in the worksheet.

Help appreciated.

ut

 

[Gord Dibben]

Multiple print jobs will handle both those problems.

You could use VBA but you would still wind up with separate print jobs.

Ron de Bruin's code would be a start.

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

 

[UT]

I will convert these pages into pdf files. Page 1, Page 2 and Page 3 will be
one pdf file. So I would like the page numbers to be displayed in the pdf
file and not just the printed copy.

Thanks.

 

[Gord Dibben]

Still two separate print jobs.

Set up Footer of Page 1 of ? for 3 pages printrange

Set up Header for 3 pages printrange.

Set your PDF application as your Printer and go.

Next print job do same.


Gord

 

[UT]

That'll work but it looks like different headers & footers cannot be inserted
on one worksheet itself for different page breaks.

Thanks!

 

[Gord Dibben]

I can only suggest after printing job one, re-header and print job two.


Gord

 

[UT]

The solution worked partly. I could change title in the header but I could
not insert page numbers for the print jobs after the first one. In the footer
when I add "&Page" it displays the actual page number and not the new page
number that I want.

From page 4 to 6, i want to restart the numbering - pg 1, 2, 3
From page 7 to 9, the same thing - pg 1, 2,3

Thanks!

 

[Gord Dibben]

Set job one print range to first three pages.........say A1:M156

After printing job one you must reset the print range to job two
range...........say A157:M312

You will get page 1 to 3 for job two

Reset print range for job three and get 1 to 3 for job three.

Header can also be changed for each job.

You could also copy pages 1 to 3 to a separate sheet and print from there.

Copy pages 4 to 6 to a separate sheet etc.


Gord

 

[UT]

Worked perfectly. Thanks a lot!!

Set job one print range to first three pages.........say A1:M156

After printing job one you must reset the print range to job two
range...........say A157:M312

You will get page 1 to 3 for job two

Reset print range for job three and get 1 to 3 for job three.

Header can also be changed for each job.

You could also copy pages 1 to 3 to a separate sheet and print from there.

Copy pages 4 to 6 to a separate sheet etc.


Gord