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
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
