I want to have a worksheet be copied, pasted immediately after that tab, and then all of the succeeding ones in that group renamed.
I have worksheets that are labeled Section 1, Section 2, etc. up to 22 (but there could be more or less, it changes.) and then I have 4 worksheets after the Sections which I don't want renamed.
I have attached a testbook that should help!
Thanks in advance to anyone who helps me
Bookmarks