Avatar of Ben Conner
Ben Conner
Flag for United States of America

asked on 

using VBA to convert single tab spreadsheet to multiple spreadsheets


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?


VBAMicrosoft Excel

Avatar of undefined
Last Comment
Ben Conner

8/22/2022 - Mon