formula query

W

Wayne Kerr

I have a group of 52 "weekly" spreadsheets , each one is named after this
week's start date in a prcise format e.g. 130305.xls. I want to create a
cell within each weekly sheet which simply contains this weeks date.
Obviously I could manually enter this data but I would prefer it if Excel
could automatically access the filename of this spreadsheet and embed it
accordingly in the cell. Can anyone tell me if this is possible?

TIA
Wayne
 
C

CLR

This from Chip's page, it works for me.........

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

All on one line, watch out for email wordwrap...........

Hold down Ctrl-Shift and highlight all your sheet tabs and then paste this
formula into a cell..........it will appear on every sheet and bring in the
name of the sheet it's on...........NOTE:, file must be saved
first..........

Vaya con Dios,
Chuck, CABGx3
 
Top