Forum Discussion
Automatic update of Cell filename Worksheet name value from one sheet to the other
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)))
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!
