I have two spreadsheets.? One is a list of employee names and hours worked according to paycode.? I need to add the hours for paycodes OT and RG matched by employee names and then add that value to another spreadsheet, again, matched by the names in the spreadsheet.? This needs to be an automatic function which the user can just click a button to perform the task.? File names can be adjusted to suit.
I need to know the code, and where to put the code to make it run correctly.
Thanks!
## Deliverables
Sorry, I don't know if I made it clear that the hours of paycode RG and the hours of paycode OT need to be added together before they are placed in the second workbook.? This will be updated monthly on seperate sheets in the workbook according to month.? I have attached the two WB that will be used so that you have an idea.
Thanks!