I have the following formula on a worksheet called "Master"
If works find but I need to exclude the worksheet name of "Master"
What Im experiencing is that the Value of B2 may appear on worksheets "Master" and another worksheet
The formula as is returns "Master", but I want it to exclude referencing "Master" and then return the value shown in B1 from any other worksheet in the workbook.
=SUBSTITUTE(CELL("filename",B2),LEFT(CELL("filename",B2),FIND("]",CELL("filename",B2),1)),"")
If works find but I need to exclude the worksheet name of "Master"
What Im experiencing is that the Value of B2 may appear on worksheets "Master" and another worksheet
The formula as is returns "Master", but I want it to exclude referencing "Master" and then return the value shown in B1 from any other worksheet in the workbook.
=SUBSTITUTE(CELL("filename",B2),LEFT(CELL("filename",B2),FIND("]",CELL("filename",B2),1)),"")