Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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

Different Page Numbers In Worksheet w/Page Breaks
 

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