Excel macro to create hundreds of workbooks with names & date from one master file, based on a template
Posted on 2013-12-18
I have an Excel workbook called Master.xlsx.
The first row contains column headers.
The first cell in each row, starting at A2 through to A1200, contains a number, like 12345678, which is to be the new filename.
Columns B through AZ contain data I want to be written into each new workbook.
The end result is to be 1200 new files with names generated from column A each with row 2 popultaed with data from Master.xlsx.
The new files are all to be based on a template with formatting called MasterTemplate.xlsx which already has the first row populated with column headers the same as Master.xlsx.
I would like all the files to be created in folder D:\GeneratedWorkbooks
Thanks in advance!