Summarizing Data

Hi,
I have a sample excel data which has 5 columns. I want to summarize them based on IDs and Work Time. So, for each ID, I need to sum its corresponding Work Time values and at the same time, keep other corresponding data too. For better understandings, I provided my desired final solution in sheet 2 (the answer should be written in a new sheet).
I think that I need to use VBA Dictionary.
Please help me out (Please note that I just need VBA code, not Power Pivot).

I wrote a code but I couldn't continue. I failed to complete the code. I'm new to VBA Dictionaries and don't have enough understandings of dictionary usage in different situation yet.

Please Login or Register  to view this content.

Originally Posted by vba_php

can you post what you've already tried? the code to do this is very simple, but i would be interested to see what you've tried first. and by the way, SUMIF() will work for millions of lines of data. the count of rows is irrelevant. I just thought you could use it to your advantage.

I need to use VBA dictionar.

Please Login or Register  to view this content.

I learned this type of code in a tutorial but the tutorial aim was something else. I tried to solve my problem by that dictionary method but I failed. I'm sure VBA dictionary can do it.

Although it looks like you might have solved this, here is another code that may help. It's not pretty, but it worked for me on your data. I compared this outcome with that of Post#6 and found you must identify the whole range in that code, but this code can dynamically size to the data automatically.

Please Login or Register  to view this content.

Your result of 103 should be 5 not 3.9...

Please Login or Register  to view this content.

Originally Posted by jindon

Did you?
https://www.excelforum.com/excel-pro...-a-report.html

I asked similar question before, but I made some changes to correspond this new problem. Actually, you helped me