formula query

  • Thread starter Thread starter Wayne Kerr
  • Start date Start date
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
 
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
 
Back
Top