How to remove rows based on filters and calculate sum of work time

[fa2020]

Hi everybody,
I have provided an example excel sheet which is just for testing. I'll try to expand it to my real world problem (my real world problem has thousands of rows). I want to filter my row based on Type C and create a list which contains sum of work time for each date. I think I need to work with arrays in VBA. I'm weak in Arrays. I need your help to study the code.
Please add some notes between your code and explain each step (I'm new to VBA)
Thanks.

[Kaper]

How about using pivot table for this task? Will easily and quickly deal wit thousands of rows.

[fa2020]

How about using pivot table for this task? Will easily and quickly deal wit thousands of rows.

Can't VBA handle this to automate the process each time I update my file?
I want to progress in VBA. Such challenges teach me lots of things about VBA programming.

[Kaper]

Sample code:

Please Login or Register  to view this content.

PS. Don't quote whole post - everybody can see it, so it's just clattering. Sometimes selective quoting is useful, but whole post - almost never.

[fa2020]

Ok, very nice code. Can we add personnel name to the left of each date cell?

[fa2020]

What is dictionary? What does this mean? --> 'setup the dictionary (late binding, so no references needed)
Set dict = CreateObject("Scripting.Dictionary")