I am looking to rename certain worksheets based on a cell value (in B2) in an a worksheet (called 'Setup). The value in that cell is a number. I wanted to look for all only the tabs that start with 'Grpxx - othertext' and rename them to Grp(cell value). Basically looking to change the number in the sheet name to a new number.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Renaming sheets based on Cell value in another sheet
- Thread starter Wizerd
- Start date
Excel Facts
Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
