Repeat headers only when data existss

J

jhouse

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top