TABS formula Is This Possible & How

M

Mike

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
 
G

Gary Keramidas

one way

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

Gary Keramidas

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

--


Gary Keramidas
Excel 2003


Gary Keramidas said:
one way

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

--


Gary Keramidas
Excel 2003


Mike said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help. This is way too tough for me. 2
Excel Is this possible?? 3
Formula not reading date format 3
Automatically Pulling Cells from Different Tabs and Files 1
Help ~ Trying to Lookup from multiple pages 1
Making Me Crazy ~ Please Help... 1
Referencing a tab in a formula 2
Formula with dynamic tab reference 4

Top