Cell info replacement based on Sheet name change

I have a multi sheet workbook. I have two cells one on the sheet I need to change the name on and one on a separate sheet. I would like to auto populate both at the same time I change the sheet name....

excel

Philip West
Aug 12, 2018
I think I understand.

On your first sheet (lets say for this example in cell A1), enter this formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Make sure the workbook is saved, else you will just get #value

On your second sheet, enter a reference back to the first. Something like =sheet1!A1

Now when you change the name of the first sheet, the formula will update, and excel will update the reference on the second sheet for you and both cells will have the name of the new sheet.

Philip West

Steel Contributor

Aug 12, 2018

I think I understand.

On your first sheet (lets say for this example in cell A1), enter this formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Make sure the workbook is saved, else you will just get #value

On your second sheet, enter a reference back to the first. Something like =sheet1!A1

Now when you change the name of the first sheet, the formula will update, and excel will update the reference on the second sheet for you and both cells will have the name of the new sheet.

William Wickware

Copper Contributor

Aug 12, 2018

Thank you. Will give it a try.

Forum Discussion

Cell info replacement based on Sheet name change