Tab Name Shown In Another Sheet's Cell
 

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

Tab Name Shown In Another Sheet's Cell
 

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


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=479563