Can anyone provide help on copying a sheet programmatically, check the last sheet number, then rename automatically with an increment of 1
First Sheet is named "Summary Sheet"
Second Sheet is named "Group 1"
Third Sheet is named "Group 2"
I would like to press a command button which will copy a master hidden sheet in the workbook named "MasterGroup", lookup the last sheet name in the workgroup "Group 2", then paste the worksheet and rename automatically with an increment of 1.
i.e. "Group 3"
I very much appreciate any assistance