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

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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

Thanks!

"Gord Dibben" wrote:

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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


Gord

On Wed, 14 Jan 2009 06:58:05 -0800, UT wrote:

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

Thanks!

"Gord Dibben" wrote:

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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" wrote:

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


Gord

On Wed, 14 Jan 2009 06:58:05 -0800, UT wrote:

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

Thanks!

"Gord Dibben" wrote:

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

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


On Thu, 15 Jan 2009 06:19:01 -0800, UT wrote:

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" wrote:

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


Gord

On Wed, 14 Jan 2009 06:58:05 -0800, UT wrote:

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

Thanks!

"Gord Dibben" wrote:

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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

Worked perfectly. Thanks a lot!!

"Gord Dibben" wrote:

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


On Thu, 15 Jan 2009 06:19:01 -0800, UT wrote:

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" wrote:

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


Gord

On Wed, 14 Jan 2009 06:58:05 -0800, UT wrote:

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

Thanks!

"Gord Dibben" wrote:

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


On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:

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" wrote:

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

On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:

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