I need a macro to move the contents of 5 columns (A-E) on one sheet to the
bottom of a set of data on another page. Variables to deal with:
1) There will be a variable amount of rows on the first sheet,
2) the end of the data set on the second page will move down each time new
data is added,
3) There are sum() formulas at the bottom of the second page in columns
(A-H) to total the data above - note there are more columns on second page.
I need the contents of the first page to be added above the "total" row and
have the sum() formulas move down accordingly in columns (A-H).
- Note: I have an empty row between the data on page 2 and the sum() row.

I keep getting an error message that says the paste area has to be the same
size as the copy area.

Any thoughts?