Link to a tab

  • Thread starter Thread starter JimS
  • Start date Start date
J

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.
 
The file must be saved for this to work:

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