I need some help with VBA code to copy a template tab multiple times and rename each new tab from a list.
* My template tab is called StudentA
* My list is in a tab Data Input cells A4:A50
What I currently have is:
Dim i As Integer
Dim wks As Worksheet...
I would like to create a macro that would bring up an input box or preferably a list box that will allow me to input information for a sheet/tab name where where "TBL NPL NGRPL" appears in the code at the end of this message. The macro needs to be available to any new file created...