So if I study the use of macro's more in depth I will be able to achieve my
goals?
thanks for your response Don

"Don Guillett" wrote:

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.