I am quite new to VBA. I have a workbook that gets a sheet added once a week. I am having to do it somewhat manually, because I can not figure out how to get them to rename properly. The first sheet is "Info". It contains information that is used on all the sheets. The next sheet is "Template". It is the sheet I want to copy. After that are the sheets being added. They are named "Week1_1", "Week1_2", and so on. The first number in the name is the present quarter and the next number is the week within the quarter. So after a few weeks it needs to change to "Week2_1".
This is what I want the code to do. I have not came up with anything that even is close enough to give as a starting point.
1. Copy sheet "Template" to end position in workbook.
2. Check list for last used sheet name, and rename the newly copied sheet with the next sheet name.
The list is in "Info", A50:A88.