I have an Excel template for invoicing manually and I'd like to automate the key variables, i.e. date, reference, amount and description.
I have these variables in a separate Excel file
Date Reference Amount Description
1/1/2016 Inv 2016-001 7500 Fees etc

How can I create a code to run through this list and create for example 50 unique invoices as Excel files and post the in a directory? Maybe one can give me the direction to create the VBA code myself. I doubt there is a ready template to use.

Thanks.