Worksheet Name used in formula

[MGP]

I have several sheets in my file and I need to use the
name of the sheet in one of it's cell. Is there any way
of doing this in 2k?

Example: I have sheet A, B and C and I need to have A2 in
cell B22 of sheet A and B4 in cell B22 of sheet B, etc..

MGP

 

[Frank Kabel]

Hi
enter this in your cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

to get the worksheet name of the respective worksheet

 

[MGP]

Frankly ... your a life saver!

Thx a million

-----Original Message-----
Hi
enter this in your cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND ("]",CELL("file
name",A1),1))

to get the worksheet name of the respective worksheet


--
Regards
Frank Kabel
Frankfurt, Germany

I have several sheets in my file and I need to use the
name of the sheet in one of it's cell. Is there any way
of doing this in 2k?

Example: I have sheet A, B and C and I need to have A2 in
cell B22 of sheet A and B4 in cell B22 of sheet B, etc..

MGP

.