I got a Tough One here.
How can i make an excel spreadsheet ALWAYS save automatically by just closing it with the X on the top right corner, BUT, it will have to save it with the requirements below:
1. This spreadsheets must have " Avery " as the prefix
2. This spreadsheets must contain whatever data is in cell (B6) AFTER the prefix
3. This spreadsheets must contain whatever data is in cell (B4) as the suffix.
IE:
Cell (b4)'s data is "C15" and cell (b6)'s data is "Joe Blow".
Once i open the spreadsheet, input the daily data in (A1:F23) all i have to do is close it, and it will save as " AveryJoeBlowC15 " in the specified folder of my choice.
Can anyone help me. I need this badly. I spend too much time making another spreadsheet with different data ( a lot of the times i save over another file...grrrrr) and i would like to use the same spreadsheet over and over again, with different customer names, and know i couldn't mess it up even though i tried. This will help me get organized, look up spreadsheets by customers names, and quicker to get from a finished spreadsheet to a blank spreadsheet.
Thanks in advance.
Bookmarks