Working with worksheet names........

  • Thread starter Thread starter heartbreakkid
  • Start date Start date
H

heartbreakkid

Is there someway u can use info in a cell to refer to the workbook nam
in the formula of another cell;

e.g
I got "ret" in cell A1;
and i got ###!b2 Where i want ### to be info in cell a1 e.g ret

is there someway u can refer to cell a1, instead of writing the name o
the worksheet
 
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
 
Hi

=INDIRECT(A1 & "!B2")
This works with single-word referred sheet name - otherwise you have to
modify it.
=INDIRECT("'" & A1 & "'!B2")
 
Back
Top