VBA LOOP to copy a hidden sheet n number of times and naming them based on rows
Hello All,
Back here again with something that seems like it should be simple but I cannot get my head around it.
I have a workbook where there is a table (unfortunately not a real table, and it uses merged cells due to needing to comply with formatting of the template) and the table will eventually contain different “Sleeve ID” down the first column. Depending on the day, that column might have 1 “Sleeve” or 30 and the naming might not be in order (i.e. SLV-001, SLV-003, SLV-004, SLV-008). Once this first table has been populated – at least for the first sleeve ID column – I would like to have a macro that can be selected that will then unhide a hidden sheet and copy it the amount of times that there are rows filled with sleeve ID’s in the first table and then name each sheet as the Sleeve ID for each of the filled in rows in that first table.
SUMMARY: when macro is run I would like to:
-Unhide the hidden template sheet (sheet1 in my attached report)
-Create a copy of “sheet1” for each SLEEVE ID filled in on the main page in the table
-Name each created copy as each of the sleeve ID names written in the first table.
Currently I can create blank worksheets based on number of rows used in the first page, and name them correctly but I cannot figure out how to use my created template that I would like to use instead of creating blank sheets.
Please see attached
Hello All, Back here again with something that seems like it should be simple but I cannot get my head around it. I have a workbook where there is a table (unfortunately not a real table, and it uses merged cells due to needing to comply with formatting of the template) and the table will eventually contain different “Sleeve ID” down the first column. Depending on the day, that column might have 1 “Sleeve” or 30 and the naming might not be in order (i.e. SLV-001, SLV-003, SLV-004, SLV-008). Once this first table has been populated – at least for the first sleeve ID column – I would like to have a macro that can be selected that will then unhide a hidden sheet and copy it the amount of times that there are rows filled with sleeve ID’s in the first table and then name each sheet as the Sleeve ID for each of the filled in rows in that first table. SUMMARY: when macro is run I would like to:-Unhide the hidden template sheet (sheet1 in my attached report)-Create a copy of “sheet1” for each SLEEVE ID filled in on the main page in the table-Name each created copy as each of the sleeve ID names written in the first table. Currently I can create blank worksheets based on number of rows used in the first page, and name them correctly but I cannot figure out how to use my created template that I would like to use instead of creating blank sheets. Please see attached Read More