Hello all,
I am trying to find a macro that allows me to copy my template sheet (JNH) multiple times but rename it based on a user input box. I can find macros that give input boxes to determine how many times to copy the template sheet and macros that give a user input box to rename a single sheet, but I cannot find a way to combine the two. My template sheet is "JNH". I want to copy the sheet, say, 5 times and have an input box pop up where I can type 5 custom names
I am trying to find a macro that allows me to copy my template sheet (JNH) multiple times but rename it based on a user input box. I can find macros that give input boxes to determine how many times to copy the template sheet and macros that give a user input box to rename a single sheet, but I cannot find a way to combine the two. My template sheet is "JNH". I want to copy the sheet, say, 5 times and have an input box pop up where I can type 5 custom names