Daily Production Reporting

Hello All
I need some help and ideas on how to setup an excel file for daily production reporting
We have around 15 operators. What I need is an excel file for each that they use
Excel files for each as they would want to start or finish at the same time so cant use one excel file

When they start the job they enter the production order number and click on start
this data should then get copied to another excel file
So every time an operator starts, stops or finish's a job the details (Production order number, Start time, Operator name. If there are delays. Reason for delays) are copied to the last row on the excel file

Then I need a report that shows when a production order number was started at this time and date and took this long to build

There could be more than one operator working on the same production order at the same time

I have attached a screen shot of how the report should look

Thank you
Regards
Rahul

Hi noboffinme
I have created an example
This can change to achieve what I am after

I have attached the excel file and the screen shot of an sample I found
Which I hope to replicate
Thanks
Rahul

Hi Noboffinme
Sorry for the late reply
I was designing and setting up the input excel file
I have attached it. There is more needed on the file
But it gives you an idea how the data will be inputted, saved to the flat worksheet

How to get this data to the main file, I have no idea

There will be 15 to 20 files that will feed the data

Any ideas on how I can achieve it would be much appreciated

Thanks
Rahul

Hi
We are a small business and no I can't get ms access
Life would be so much easier if I did
I have access to SQL server, but have never used it so I'm not so confident using it

Would it be possible using excel?

Hi
Just trying some codes to use VLookup in the user form
but am getting an error
Can anyone advise where am I making the mistake?

Private Sub FirstName_AfterUpdate()
'Check to see if value exists
If WorksheetFunction.CountIf(Sheet1.Range("C:C"), Me.FirstName.Value) = 0 Then
MsgBox "You Have Entered An Incorrect Name"
Me.FirstName.Value = ""
Exit Sub
End If
'Lookup values based on first control
With Me
.LastName = Application.WorksheetFunction.VLookup(Me.FirstName), Sheet1.Range("EmpLookup"), 2, 0)
.StaffID = Application.WorksheetFunction.VLookup(Me.FirstName), Sheet1.Range("EmpLookup"),2,0)

End With

End Sub

Thanks

Hi Noboffinme,
Thanks for links. I needed that
I am still working out how to fill the database when the user enters data in the user form

Thanks

Hi Noboffinme
I have been working on the file and I have got some of it working
Got the code for the Clock On and Start Job working

I have been thinking and think need to make a minor change to way the form interacts
These excel files are dedicated to individuals, so I am wasting time getting them to fill their names and Staff ID every time they use the form
Is it possible in the setting sheet, a user is selected and then the first three data become default for this excel file and forms (Staff ID, First Name & Last Name)

I have attached some screen shots and the latest excel file with my VB Coding

Thanks
Rahul