I have pretty basic knowledge of writing macros and i am struggling with creating a macro to automate my invoicing process. (I am using Excel 2010)
I have the data which is pivioted e.g below.
Affiliate ANML1 ANML2
A023 1,000,000.00 2,000,000.00
A375 500,000.00 600,000.00
I want to use an existing template saved in the spreadsheet to create a new invoice on a new work sheet.
i.e a new worksheet named 'ANML1 - A023' & 'ANML1 - A375' (seperate sheets) which has the template format, another worksheet named 'ANML2-A023' & 'ANML2 - A375' (seperate sheets) which has the template format.. and so on....
The next step will be to populate the data into the invoice, to which i dont know but the above would be extreamly helpful... SOMEONE PLEASE HELP!!!!! :)