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

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.
 
D

Don Guillett

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get data from invoice template 1
Post instructions to link a spreadsheet to a form, like invoices. 1
Excel,increase Invoice Number At Start 1
How do I automatically pull a new invoice number into an excel te. 3
Auto Numbering 10
Entering data on template and then data going to a spreadsheet. 3
Excel Spreadsheet and Invoice Forms 3
Invoice Numbering 1

Top