Sheet names and cells

W

walianboy

Is it possible to get a cell to give the value of the name of th
sheet?

I am doing timesheets and my files have sheets named with particula
dates. On each sheet is a cell with that date on it also. It would b
good if this could be generated by the data entered on the sheet name.

Thanks in advance,

Richar
 
F

Frank Kabel

Hi
try one of the following formulas (note: the workbook has
to be save
before). Just use the formulas as they are shown (don't
replace
'filename' with anything else)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-
1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("file
name",A1),1))
 
L

Lee

Frank

Is it possible to take the sheet name formulae detailed below from various
sheets onto one sheet. This is what I was trying to achieve with my index
query earlier.

Cheers

Lee


Frank Kabel said:
Hi
try one of the following formulas (note: the workbook has
to be save
before). Just use the formulas as they are shown (don't
replace
'filename' with anything else)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-
1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("file
name",A1),1))
-----Original Message-----
Is it possible to get a cell to give the value of the name of the
sheet?

I am doing timesheets and my files have sheets named with particular
dates. On each sheet is a cell with that date on it also. It would be
good if this could be generated by the data entered on the sheet name.

Thanks in advance,

Richard
Click to expand...
Click to expand...
 
L

Lee

Frank

I've figured it out (I basically just need to cut and paste the formulae to
my index).

Thanks for the help.

Lee

Lee said:
Frank

Is it possible to take the sheet name formulae detailed below from various
sheets onto one sheet. This is what I was trying to achieve with my index
query earlier.

Cheers

Lee


Frank Kabel said:
Hi
try one of the following formulas (note: the workbook has
to be save
before). Just use the formulas as they are shown (don't
replace
'filename' with anything else)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-
1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("file
name",A1),1))
-----Original Message-----
Is it possible to get a cell to give the value of the name of the
sheet?

I am doing timesheets and my files have sheets named with particular
dates. On each sheet is a cell with that date on it also. It would be
good if this could be generated by the data entered on the sheet name.

Thanks in advance,

Richard
Click to expand...
Click to expand...
Click to expand...
 
Top