different footers on each page

[Bailey]

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

 

[Gord Dibben]

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

 

[bailey]

I have multiple pages on one worksheet.

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

 

[Gord Dibben]

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

 

[bailey]

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.

 

[Dave Peterson]

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.

 

[Bill Sharpe]

I have multiple pages on one worksheet.

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