I need to create several hundred customised Excel files.
I have a template file with a bunch of field names as the first row. The second row is to be filled in by the recipient.
I have a master file with two columns which contains the name I want for each file, which is a number, like 92625785965 (an ABN, in fact) and a Company Name.
The company name needs to go into cell A2.
How can I go about this in an automated fashion?