Dear Friends, I need a VBA Access function that has two Array Arguments, the first array is a list of Items:
The second array is a product structure, like this one:
So you have to do some calculations:
And the final result, should be this one:
Kindly note I have marked in Yellow the values that were grouped/sum
I hope you can help me. I have been fighting with this one for weeks.