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

Consolidation Table from Different Excel Tabs with Different Format 1
Is this possible? 0
How to set tabs in work document 0
VBA Coding Help for Beginner 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Drop down list control value in vba 2
Please help. This is way too tough for me. 2
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top