Worksheet Name used in formula

  • Thread starter Thread starter MGP
  • Start date Start date
M

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
 
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
 
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
Click to expand...

.
Click to expand...
 
Back
Top