Linking Tab/worksheet names to a worksheet cell

[LinLin]

Hi Everyone

Is there any formula I can put in a cell so that it shows the tab/worksheet
name?

IE If my Tab name is "Supplier 1" I would like to have a cell in my
worksheet which says Supplier 1.
(Yes I'm lazy and hopefully there is a way to achieve this! Can't see the
point in typing it twice, risking typos etc...)

thanks!

 

[Sheeloo]

Try

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

in any cell...

 

[Sheeloo]

Formula works only after the file is saved at least once.

 

[Gord Dibben]

You must include a cell reference......any one will do.

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

For explanation see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

Try

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

in any cell...

Hi Everyone

Is there any formula I can put in a cell so that it shows the tab/worksheet
name?

IE If my Tab name is "Supplier 1" I would like to have a cell in my
worksheet which says Supplier 1.
(Yes I'm lazy and hopefully there is a way to achieve this! Can't see the
point in typing it twice, risking typos etc...)

thanks!