using VBA to convert single tab spreadsheet to multiple spreadsheets
Posted on 2016-08-30
I have a spreadsheet I'll be creating with provider id as the 1st column and other fields from columns 2-11. I need to take this spreadsheet and a template spreadsheet and create new spreadsheets from the original, with the template info at the top of each of them. The name of the new spreadsheets would be the provider #.
Working in Excel 2016. Would love to be able to do this in batch mode if possible, as there will be a lot of spreadsheets created.
Can anyone give an approach to take that I can start with?