Hi here i have created an invoice and would like to take the data for (date, invoice no, customer name and amount)
into a seperate workbook that is my years summary sheet, it has multi sheets in profit loss, invoice summary, parts used, petrol cost etc.
I would like to get the data from my invoice to go into the invoice summary on the sepeate workbook.
each invoice is the same i have a macro that regenerates the invoice number to the next invoice saves it as the invoice number and prints it thats great all i want it to do now is add the amount to the workbook for the year any help people.
invoice workbooks are saved as standard exel book seperate and in order named inv13001, inv13002 ect
the sells in this workbook i need the data from are:
date:- g3
invoice no:- g4
customer name:- g5
amount:- g39
and to go into my other workbook called (in house) and the sheet (invoice summary)
i need the data name the same as above to go into the cells
date:- b4
invoice no:- b5
customer name:- b6
amount:- b7
but once the button on the invoice page is pressed it now clears all info, saves an generates a new invoice which is great but i want it to add the info to the sumary but the row below each time so they stay in order it already adds itself up thats not a problem just need the data to be added below each other as a invoice is created thanks alot paul