I have many IDs, I need to get the sum of "Total hours" column that has the same IDs then write it to another excel file with sheets that has the same IDs

[ppr (Peter Preuss)]

Topic is forked to

I have 2 excel file, I need to get the total working hours and ot hours for an employee then write it to another excel file on the sheetname that depends on the employee name with a specific cell

EmployeeRecords.xlsx (8.3 KB) TotalRecords.xlsx (9.3 KB)