Manufacturing Schedule Needs updating

[bguthrie]

I am in a manufacturing plant and we have a machine we want to do a better job keeping track of "on hand" quantity.

Our machine is connected to our network and I get a spreadsheet of every part that is made from this machine (with time stamps). However, it is up to our operators to manually input this data and almost always our BOH (bill on hand) is off due to human error (forgetting, misinput, etc.)

I am new to macros as of 2 days ago so this is a challenging task but I thought it would be possible to create a macro that would update my schedule with a push of a button. The more I looked into it, I think this is possible, but I will need a lot of help.

Things I need/address in the macro:

1. Jump from one workbook to another (parts that were completed are generated by the machine but need to be inputted on a different spreadsheet)
2. The part number needs to be matched from the machine to the other workbook to make sure the quantity is updated correctly for the right part.
3. The time and date of when the part will need to be addressed. We run 3 shifts so depending on the hour and day the part was finished needs to be translated into the other workbook to find the correct spot to say who made the part, what part was it, and how many.

I know some code so I am familiar with the theory of what needs to happen (for loops, if/then statements, etc.) but I have never done a project or seeked help like this. Let me know if I can obtain help or if I need to post something else.

[kevinu]

you'll get more response if you post a sample of your workbook then a sample of the file to import and how you want it to end up looking like.

[bguthrie]

'open cutting results and get information needed
Set mydata = Workbooks.Open("file location\1. SchduleresultsReportTest.csv")
finalRow = Sheets("1. SchduleResultsReportTest").Range("A25000").End(xlUp).Row
For i = 1 To finalRow
partNumber = ActiveSheet.Cells(i, 5).Value
Time = ActiveSheet.Cells(i, 8).Value
findDay = ActiveSheet.Cells(i, 1).Value
findHour = Hour(Time)
findMinute = Minute(Time)

Next i

Stop

mydata.Close

This is what I have so far. I can find all the information needed in the schedule results spreadsheet. Next is making an if statement (I'm guessing) and comparing with the other workbook in order to put the correct quantity in the correct part/shift combination. Problem is how do I switch workbooks and find the correct cells to compare with? Also If I press the button again will it overwrite what I have or add it to what is currently there?