Different header and footer for an excel workbook

[ElvinK]

Hi All

I have a set of data that is saved in an excel workbook.
I'll need to print in out and have a different header and footer for every page.

Any idea how Macro would be of any help?

The document will have an estimated of 120 pages.

[6StringJazzer]

Are you talking about printing a single worksheet, or more than one? What is the content of the header and footer? How will they relate to the content of the page?

[ElvinK]

A single worksheet. The header contains the revision number which would be different for each page. Footer shows the page number.

[6StringJazzer]

How is the revision number determined? Could you attach a sample file and explain how you want it to work?

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.