Hi Rachel,
with a macro that prints a page for each print,
by customizing, printing a page, customizing, printing the next page, etc.
Probably not worth the effort but it can be done.

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel...ls.htm#restart


Much simpler is to not print headers at all but to use header rows and
delay the start so the first page does not have the headers rows.
-- but then these are really excel headers and
there is nothing along this avenue for different footers.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"rachel@cpa" wrote ...
How do you have different footers on each page?