Forum Discussion
Automatic update of Cell filename Worksheet name value from one sheet to the other
Hello, I have used a formula to recover the worksheet name in a cell and when switching from one sheet to the other the update is not done in the cell - is there an option I missed that will allo...
I've had this issue before. It'll give me the same Value in all the sheets.... But, reference the cell that you're using this for. I have different tabs for different dates and they all USED TO have the same dates until I used Formula Below: ("B1" is the cell I used for this formula) All sheets will update in accordance with your tab name.
=RIGHT(CELL("Filename",B1),LEN(CELL("Filename",B1))-FIND("]",CELL("Filename",B1)))
SandovalContracting Thank you, thank you, thank you, thank you. Just stepped up from Excel 2010 to 2021 so lots to learn (or unlearn and relearn).
NS_Robert No Worries! Sometimes you just need to be specific with formulas, once you start going broader in your formulas you get more errors. Glad I can Help!
