VBA code to create new sheet from choice of templates based on cell value in a cell range.

[BokiRis]

Hello Forum,
I have exhausted every effort in searching all over different forums for a solution to my predicament. I would be eternally grateful to anyone that can find a solution to my issue.

This is what I’m trying to accomplish:

• I have one master sheet called “Master”
• There are six different template sheets called “AI Template”, “AO Template”, “AIAO Template”, “DI Template”, “DO Template”, and “DIDO Template
• In the Master sheet, for cells in cell range B12:N12 there are six different value options (SPARE, ECOM, AI, AO, AIAO, DI, DO, and DIDO
• Also, In the Master sheet, cells in cell range B13:N13 will contain the names of the new sheets created from the templates.

If it is possible, I would like to, based on the cell value in cell range B12:N12 make a copy of the corresponding template and rename it a corresponding name as derived from cell range B13:N13. One caveat is, I do not want to create any additional sheets if the value in the cell range B12:N12 is blank, SPARE, or ECOM

For additional clarification this would be an example of how it should work:

If cell B12 contains AI, insert copy of the AI Template sheet and rename it the value of cell B13. Furthermore, if C12 is AO, then insert copy of AO Template sheet and rename it the value of cell C13 and so on.
Thank you in advance!!!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ple-cell-ranges-master-sheet.html#post5338938

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).