VBA

Guys can you help me with this 1? i try so many method but still cant find any answer

im new in VBA  and here is the scenario

 

i have 4 sheets which is user1, user2, user3 and data. (the screenshot is in the data sheet)

I want to create a vba macro that will check the user ID and the worktype then send the value of " count(under H column) and Error point(under I column)

and also if you can see there is 2 similar worktype under user 1 "maid". if 2 similar worktype is on the data sheet under same userid i want to sum all the same worktype and copy it to user1 sheet

 

Thanks