Hi all,
I need VBA code for a macro to be developed.
Scenario:
I have 4 columns in sheet 1.
For example,
ID1 ID2 Sum1 Sum2
100 a 10 12
101 a 20 11
100 a 10 07
100 b 30 05
100 b 15 20
101 c 20 10
In sheet2 my sum1 and sum2 should be calculated based on ID1 and ID2.
i.e. My result in sheet2 should be as
ID1 ID2 Sum1 Sum2
100 a 20 19
100 b 45 25
101 a 20 11
101 c 20 10
The rows count always varies.