cell contents

  • Thread starter Thread starter Joe Bannister
  • Start date Start date
J

Joe Bannister

Hello all,

I have a work book with 3 sheets.
The name of sheets 2 and 3 may change.

Is it possible to have Cell A1 in sheet 1 referenced to
the name of sheet 2 and Cell A2 in sheet 1 referenced to
the name of sheet 3 so that they change as the name of
the sheets change?

Cheers

joe Bannister
 
Not directly but indirectly, somewhere of the view put this formula on all
sheets that you want to get the names from
for instance Z1

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

then refer to them on Sheet1
by a simple link in A1:A2

=Sheet2!Z1

and

=Sheet3!Z1


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top