How do I feed info from invoice I created to a Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top