Excel 2007 : header for page one

[crk140]

how can i put a unique header on page 1? i want to print two copies of the same page. on the first copy at the top i want it to read "bank copy", at the top of the second page i want it to read "customer copy"

thank you

richard keyser

[NBVC]

The easiest way would be to record a macro while setting up to print a copy with "Bank Copy" at the header...and printing it.

Then stop the macro,

Press F11 to go to the editor and edit the macro by copying the code between Sub and End Sub and pasting it before End Sub, then change the line that shows "Bank Copy" to "Customer Copy"

Now you can add a button to your spreadsheet that would be linked to this macro and print your 2 copies.