Group by and sum VBA

[track85]

Hi,

This forum has been of great help and saved myself hundred of hours of work. And I come again with another scenario that has me stumped. Trying to find a vba to automate the process. In the attached document example row 8-11
output that I'm trying to get would like row 25-26.

Thanks again

[oeldere]

You asked for VBA.

This solution is with a pivot table.

See the attached file.