name tabs

  1. M

    Copy Template multiple times and rename using list

    Hi All 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: Sub Copy_Sheets() Dim i As Integer Dim wks As Worksheet...
  2. K

    Renaming Worksheet Tabs Macro

    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...

Some videos you may like

This Week's Hot Topics