I'd use a macro to automatically open the work Excel spreadsheet, copy the relevant data into the correct columns and then save it with that day's date.
Unfortunately you need to know VBA for this, although it's straight-forward enough to be a beginner's first project.
I'd use a macro to automatically open the work Excel spreadsheet, copy the relevant data into the correct columns and then save it with that day's date.
Unfortunately you need to know VBA for this, although it's straight-forward enough to be a beginner's first project.