Copy invoice data to another workbook

Hi all!

I'm very new to using macro's and i don't really know what I'm doing.
I've got myself a bit confused with this one. I am trying to write a macro(or a couple?) which when used, opens another workbook then copy the invoice details to the second workbook, save the invoice as a seperate file, then clear the invoice and increment the invoice number, and closes the second workbook.
I think I have macros to open the second workbook, increment the invoice number and save each invoice as seperate file, however I can't seem to get it to copy data to second workbook and move down a line. in preparation for next invoice.

The first file is "Invoice template" and the details are on the sheet called "Invoice" in cells F4,F5,F6,G18,G41
The second file is called "Bookkeeping" and the sheet the need to go to is "Invoice List" starting in cells A3,B3,C3,D3,E3 respectively for the first invoice then moving down a row.

For some reason I just can't get this to work at all! I have tried recording a macro but had no joy. I must admit that the macro's I used for the other actions were not written by myself, but shamelessly google'd on the internet.
Ideally I would like to make it so that it all happens in one big macro but I don't know if this is possible?

Thank you all in advance

Hi, Gstacey,

you could use just one macro instead of 3 and combine all the functions you want in there:

Please Login or Register  to view this content.

In ThisWorkbook I added a procedure to make sure that sheet Invoice shows up on opening:

Please Login or Register  to view this content.

And I slightly worked on your Formulas as well.

BTW: you would have needed to adjust the range you wanted to clear the contents. in

Ciao,
Holger