Where's that Spreadsheet!
Filename, Filename, my filename and sheet name! We work with hundreds of spreadsheets and frequently spend hours just trying
to find the filepath location of the last instance where we used the sheet. We like to customize my Header and although Excel offers Header, the format is not our style. Here are two tips that we found for inserting the filepath and sheet name as well as the Day of Week functions - @CELL("filename",A1) and =TIME(A1,"ddd") We found these on a great site called https://exceljet.net/formulas Never loose sight of your files again!
Comments