Solution:

I created an Excel spreadsheet that allows each lead to select his report for editing or view another’s report for any other day with a macro button.

The spreadsheet (turnover.xls) resides on a network drive that is available for all computers in the shop. When a lead selects his name and clicks the macro button, the macro checks to see if a spreadsheet with his name already exists. If not it creates and saves a report under his name.  The next time he opens it the previous data is retained so he only has to edit what has changed.

After filling in his crew’s status he prints and saves with a button. The printed report and the report pulled up from the first screen if someone wants to view a previous report look likes this. .txt and a .xls reports are created with a date so it may be reviewed at any future date.

The work control clerk then opens a Word doc that is blank except for a macro button.  When she clicks the button it collects all .txt reports for each leads name and creates a word doc. If no report was done it adds a line saying that. She then emails the doc to the director.

Users required no training. No knowledge of how and where to save files or printing of reports is required as this is all accomplished with easy to read buttons on screen.