Hi guys,
As the title states, I wanted to find a way, preferably using formulas, to return the tab name of a cell that's linked to an inactive tab in an active tab.
For example,
Assuming there are two sheets in a workbook (SheetA and SheetB), and I am in SheetA (active tab) that has a cell referencing a cell in SheetB (inactive tab), the raw formula in SheetA would look something like "=SheetB!A1". Let's assume the cell referencing "SheetB!A1" is in cell C1 of SheetB. I would like to create a formula that provides the tab name of the cell I select within the active sheet linked to an inactive sheet. Therefore, in the cell right of C1 in SheetA, D1, I would like to select C1 and have the formula return "SheetB"
I found the following formula online that would display the tab name of the active tab:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
**by inserting after "filename" (within CELL formula) a cell address from an inactive tab as follows:
=RIGHT(CELL("filename",SheetB!A1),LEN(CELL("filename",SheetB!A1))-FIND("]",CELL("filename",SheetB!A1)))
It return what I am looking for--the name of the external tab--but that would require me selecting the cell directly from the source. Again, I am looking for a way to do this by selecting a cell in an active cell that's referencing a cell from an inactive cell.
I have not been able to come across a solution online, so I wanted to reach out to anyone here who may know the trick.
Thanks a million in advanced.
As the title states, I wanted to find a way, preferably using formulas, to return the tab name of a cell that's linked to an inactive tab in an active tab.
For example,
Assuming there are two sheets in a workbook (SheetA and SheetB), and I am in SheetA (active tab) that has a cell referencing a cell in SheetB (inactive tab), the raw formula in SheetA would look something like "=SheetB!A1". Let's assume the cell referencing "SheetB!A1" is in cell C1 of SheetB. I would like to create a formula that provides the tab name of the cell I select within the active sheet linked to an inactive sheet. Therefore, in the cell right of C1 in SheetA, D1, I would like to select C1 and have the formula return "SheetB"
I found the following formula online that would display the tab name of the active tab:
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
**by inserting after "filename" (within CELL formula) a cell address from an inactive tab as follows:
=RIGHT(CELL("filename",SheetB!A1),LEN(CELL("filename",SheetB!A1))-FIND("]",CELL("filename",SheetB!A1)))
It return what I am looking for--the name of the external tab--but that would require me selecting the cell directly from the source. Again, I am looking for a way to do this by selecting a cell in an active cell that's referencing a cell from an inactive cell.
I have not been able to come across a solution online, so I wanted to reach out to anyone here who may know the trick.
Thanks a million in advanced.