I have a macro that copies a table from a sheet to a
template i have set up in another workbook.

This all works fine but I have the following problem: The
table i am importing can any length from 1 line up to 200
or so but I want the template to have a page total formula
at the bottom of each page so I will need the last 3 rows
of data locked so when i import the table it will leave
these lines blank and move the rest of the table to the
next page.

Sorry for my explaining skills.

Is this poss?

Thanks