Hi,

I work for a printing company and on one of our presses, the operators manually write out time sheets to record their work. This in turn has to be typed up in Excel to do some analysis on performance etc. I am trying to change this so the operators input the information directly into Excel from their terminal. I would like to utilise some of the features that VBA allows to make input easier, and also automate the analysis of the input to produce KPI’s without manual intervention.

The problem is, I can’t write in VBA! I was hoping to call on the experience of this forum that has been extremely helpful for me previously!
My ideal solution would be as follows:

“Home page” there is an Excel worksheet simply with a button “Start Shift” by pressing this button, the user has an option to complete: “Operator” (ideally this option would be from a drop down list that has been specified) – once this has been selected there is pre-formatted layout:

Job No Time Started Time Finished Clicks % complete Comments


The operator would then fill out each row of data with the relevant information as they produce each job.

At the end of the shift, there would be a button on the Excel worksheet “Finish Shift”. When the operator would press this button, they would be prompted to enter the “machine reading”.

After doing this, the macro would cut all the data on the worksheet and paste it into separate Excel workbook on the network. The data would be in exactly the same format recorded above, however there would be 2 x additional columns: “operator” & “date”. The operator text string captured when pressing the “Start shift” button would be recorded & it would also need to record todays date and insert that into a separate column.

On the same workbook on a different worksheet, the “machine reading” figure would be inserted into one column and the date into an adjacent one.

The other workbook on the network would then have all the shifts recorded, and analysis would be carried out on that.

I hope someone can help with this – many thanks in advance!