Hi all,
I'm looking for a macro, that would run through all worksheets in a workbook and change their name from xxx1 to xxx2, xxx2 to xxx3, xxx3 to xxx4, xxx4 to xxx5 and xxx5 to xxx1. There will be 2 other worksheets in that file so only those that have a digit in their name shall be changed to +1 (max 5).
Thanks
Bookmarks