Forum Discussion
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. Any help is appreciated.
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.
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.
Thank you. Will give it a try.
Thank you again for the help. The first formula works great, but I am having to play with the other. Thanks again you have placed me on the correct path.
William
