Help required creating multiple page invoice template

[Anthony_Griffiths]

Good evening,

I am trying to create an invoice template in excel that will, if necessary, use more than one page.

On each page I require all headings and titles to be the same, including footers, with only the product listing changing.

I am using IF and VLOOKUP to pull the 'Invoice To' and 'Ship To' data that needs to be shown on all pages.

I am using IF and VLOOKUP to pull the product data that I require, with simple equations to determine line value and total value.

I only require the total sale amount, balance due etc to be shown on the last page.

Many thanks,

Anthony.