Hi,

I am new to the VBA editing and I am missing some steps to get my files correctly generated and then ideally saved in PDF format in the same folder.

I have two files; one is an invoice template with the following fields:

Invoice Reference: Line 8 column D
Issue date: Line 9 column D
Client name: Line 11 column E&F
Client address: Line 12 column E&F
Product name: Line 16 column E&F
Product details: Line 18 column E&F
Production date: Line 20 column E&F
Delivery date: Line 22 column E&F
Units: Line 24 column E&F
Total Units: Line 26 column E&F
Total Invoiced: Line 30 column F

Each sheet in the "template" workbook should be named after the Invoice Reference.

Secondly I have the source file in which the data is organized as follows: (Both are in the same folder)

Invoice Reference: column A
Issue date: column B
Client name: column C
Client address: column D
Product name: F
Product details: column G
Production date: column H
Delivery date: column I
Units: column J
Total Units: column J
Total Invoiced: column E

One invoice needs to be created per line in the source workbook.

I would be very thankful if anyone could help me out with this as I tried many times the macro recording without getting the correct outputs.

Best regards,

Benjamin