Home » Forums » Open Source Learning Center » Question and Answer

auto fill cell with sheet name

Submitted by cw1 on 4 November, 2013 - 18:07

hi,
i need to rename a daily sheet with the date on the tab at the bottom of the sheet. how do i get this to autofill into a specific cell on the sheet? eg 4.11.13 to cell a1.

‹ excel Adding file count and folder size to current macro, can this be done or does the code have to be rewritten? ›
»

I think you

Submitted by chris on 20 January, 2014 - 19:04.

I think you want:

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

Chris

»