Sum the corresponding data of matching value from Another Sheet

Hi All

Hope everyone is fine.

I searched many forums and google it but did not get the expected result.

Facts:

I have two worksheets, In Sheet4 Range L10:L1000, M10:M1000 & N10:N1000 have data and Matching Column is P10:P1000

Now In Sheet 3 W10 Value check through Sheet4 P10:P1000 if Matched found then it sums the matched value L10:L1000 data to H10, M10:M1000 data I10, and N10:N1000 data to J10.

It goes the same as from W10 to last available data in the W10:W column in sheet 3.

Can It Do with VBA coding?

If so, then it will be so great for me and highly appreciated.

Thanks in Advance.

Thanks, RoyUK for your response.

If it is possible with VBA then I think it will be best.

Here I attached my file Time_Table.zip

Thank you in Advance for the help.

Thanks, RoyUK,

Actually, I data moved from Sheet 4 to 3 as summation based on ID, After that other sheet2 works based on the value of sheet 3.

In that case, PivotTable does not fulfill my objective. Yes there is a problem result for 133428 is incorrect because those values formatted differently

And I change all the values as [hh]:mm:ss formation.

Can It do by formula or VBA ?

Thanks again and appreciate your support as always.

Thanks Royuk

Yes, It is the faster way but I need to make some analysis based on that sheet and which result shows up in another sheet. I need data for the specific cell as mentioned earlier.

Thanks.