TABS formula Is This Possible & How
 

I have 50 worksheets in work book each Tab has a different date Say Jan.31 &
so on. So what i want to do is in cell B2 on each sheet have the Tab name. Is
there a formula for this. Because when i change the tab name in future i want
cell B2 to follow suit

TABS formula Is This Possible & How
 

one way

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))

--


Gary Keramidas
Excel 2003


"Mike" wrote in message
...
I have 50 worksheets in work book each Tab has a different date Say Jan.31
&
so on. So what i want to do is in cell B2 on each sheet have the Tab name.
Is
there a formula for this. Because when i change the tab name in future i
want
cell B2 to follow suit

TABS formula Is This Possible & How
 

this may work, too
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,999)

--


Gary Keramidas
Excel 2003


"Gary Keramidas" wrote in message
...
one way

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))

--


Gary Keramidas
Excel 2003


"Mike" wrote in message
...
I have 50 worksheets in work book each Tab has a different date Say Jan.31
&
so on. So what i want to do is in cell B2 on each sheet have the Tab
name. Is
there a formula for this. Because when i change the tab name in future i
want
cell B2 to follow suit