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

[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

 

[Alex]

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

 

[Arvi Laanemets]

Hi

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

 

[heartbreakkid]

Thanx ya'll..... that works perfect..... iam sorry for my ba
english...