How can I enter different footers on each page in a workbook without all
pages having the same footer?

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?

I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?

A unique footer on each page would require a separate setup for each page anda
print job for each.

You could do it with VBA but it would still wind up as separate print jobs.

See Ron de Bruin's site for sample code which would have to be modified.

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


Gord Dibben MS Excel MVP

On Sat, 26 Apr 2008 11:35:00 -0700, bailey
wrote:

I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?

I only need the center footer to read differently on each page. For
example, on page 1, it should read "Net Cash Flows" and on page 2, it should
read "Net Working Capital", and on page 3, it should read "Summary Tables",
etc. If I enter the center footer on page 1, it is automatically copied to
the remaining pages. Do I have any other options?
Thank you for your help.

"Gord Dibben" wrote:

A unique footer on each page would require a separate setup for each page anda
print job for each.

You could do it with VBA but it would still wind up as separate print jobs.

See Ron de Bruin's site for sample code which would have to be modified.

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


Gord Dibben MS Excel MVP

On Sat, 26 Apr 2008 11:35:00 -0700, bailey
wrote:

I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?

Record a macro when you
change the footer for page 1 and then only print page 1
Keep recording when you change the footer for page 2 and print page 2
and keep recording while you are changing the footer and printing that page.

After you're done, stop recoring the macro.

Next time you need to print this stuff, just run the macro that you recorded.

bailey wrote:

I only need the center footer to read differently on each page. For
example, on page 1, it should read "Net Cash Flows" and on page 2, it should
read "Net Working Capital", and on page 3, it should read "Summary Tables",
etc. If I enter the center footer on page 1, it is automatically copied to
the remaining pages. Do I have any other options?
Thank you for your help.

"Gord Dibben" wrote:

A unique footer on each page would require a separate setup for each page anda
print job for each.

You could do it with VBA but it would still wind up as separate print jobs.

See Ron de Bruin's site for sample code which would have to be modified.

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


Gord Dibben MS Excel MVP

On Sat, 26 Apr 2008 11:35:00 -0700, bailey
wrote:

I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?





--

Dave Peterson

bailey wrote:
I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?

The simple solution is to put each of your pages on a separate
worksheet. Then you can specify whatever you want for the footer on each
of the worksheets.

Bill