I am trying to create an invoice in Excel. The invoice consists of 3 sections:

Header info (cust name, address, etc)
Body (where the amounts owing is displayed - with the following column
headers Invoice #, Due date, currency, amount owing)
Footer info (instructions for payment, closing comments, page #, etc)

My problem is that I am importing data (of varying amounts) into the body
section and I want the column headers for the body section to repeat on each
additional page... but only if there is invoice data on the last page. If the
last page break occurs in the middle of the footer info, I do not want the
column headers to repeat.

Any suggestions?