Response 2 to Need help to gather staff times
Martin,
two files attached. MD master is the file which collates the data from the timesheets. TS1 is a timesheet. Note I have amended the timesheet format slightly so this will need to become your new template timesheet (see notes).
I recommend you error check for mathematical errors before deploying.
The master workbook also has a populateallrnd macro which will populate all timesheet workbooks within a folder with random numbers.
Any probs/questions email me at andrewlitchfield@gmail.com for fine tweaking
Attachment | Size |
---|---|
MD Master.xlsm | 56.91 KB |
TS1.xlsx | 419.37 KB |
»
- AndyLitch's blog
- Login or register to post comments
- 2471 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago