You would need a macro to do this project of finding the next row on the
destination sheet and copying there. Put it in the before print of the
ThisWorkbook module.

--
Don Guillett
SalesAid Software

"cjtaylor1969" wrote in message
...
I want to create one template invoice to be used repeatedly, and each time
a
new invoice is created from that template, all of the info on the invoice
will feed into an excel spreadsheet, the spreadsheet will summarize all of
the invoices.