cell contents

[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

 

[Peo Sjoblom]

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)