Sheet Reference

E

Etienne Borg

I have cell 'D8' which contains a formula linked to
another sheet ie ='Payroll CC100'!D10. Payroll CC100 is
the name of the other sheet. Is it possible to have a
formula whereby cell 'C8' ie next to 'D8' indicates the
sheet name (ie Payroll CC100) linked to 'D8'.

Can anyone help?
 
D

Dave Peterson

A small typo:
=INDIRECT("'" & C8 " "'!D10")
should read:
=INDIRECT("'" & C8 & "'!D10")
 
E

Etienne Borg

What i really need is that in cell C8 i will have the name
of the precedent sheet of D8.
 
D

Dave Peterson

I'm not sure I understand, but maybe:

=INDIRECT("'" & C8 & "'!D8")

This will return the value from D8 in the sheet named in C8.
 
J

Jack Schitt

It doesn't sound like a trivial problem.
I feel that any solution is going to start with your using a specific cell
in each worksheet whose name you may eventually require, in order to store
the name of that sheet.
Suppose you use cell A1 for that purpose.
Then, in that cell
=RIGHT(CELL("format",A1),LEN(CELL("format",A1))-FIND("]",CELL("format",A1)))
will return that sheet's name.
Now in your cell C8 you could simply refer to that cell, and if the name of
the sheet should be changed then so will that returned value.
I suspect that this is inadequate for your purposes, but any solution is
likely to start with this approach.
 
Top