Tab Name Shown In Another Sheet's Cell

J

jbtenor1

Is it possible to pull the tab name from another sheet within the same
workbook and show it in a cell?
 
B

bill k

you need to get the tab name in a cell in the original sheet first

use the formula in for example cell B2
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

then on the other sheet you can refer to............... =sheet1!B2
 
Top