auto fill cell with sheet name
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.
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 469 guests online.
New Excel Experts
Current Excel / VBA Jobs |
auto fill cell with sheet namehi, |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
I think you
I think you want:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
Chris