Link to a tab

[JimS]

Can you link a cell to the name in a worksheet tab?

I have five tabs open across the bottom and one of them is called
records. Can I make a cell in the records tab simply say "records?"

So when I name a tab cell a1 mimics that name.

 

[RagDyer]

The file must be saved for this to work:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

 

[JimS]

Thanks, works great.

 

[RagDyeR]

You're welcome, and thank you for the feed-back.