Forum Discussion
Solved
Updating Sheet Name References after Changing Sheet Name
I want to be able to change the names of all my sheets without needing to change the formulae for the sheet references I have a macro that automatically changes the sheet names for...
I do understand that when using sheet name references under normal circumstances, the formula does re-write itself if you change the sheet names. But you can see here that after I change the names to Feb, if I use the INDIRECT function to call the sheet references, the formula doesn't automatically change.
I've found a work around using find and replace, it should be all good now. Though if you have a simple solution that doesn't need find and replace, I'd be open to hearing it.
Hoping this will help - you should be able to include this in your formula by replacing the "1-Jan-2022".
As you can see, the formula updates even after the sheet name is revised.
Hope this helps.
Dexter
=RIGHT(CELL("filename",Test3!O5),LEN(CELL("filename",Test3!O5))-SEARCH("xlsx",CELL("filename",Test3!O5))-4)