Can an expert help me out with this please.
In my spread sheet there are codes in column ‘C’ Some of these I do not want to touch, others I need to merge the amounts.
So, I think I need VBA code where I tell it what codes to look at.
In the attached spread sheet you will see I have ‘IC123,4 and 5 which I do not want to touch. I have codes 700001 through 700021 which I need the VBA to work on.
I need to look at each code and where there are more than one of the same code, total them, put the total in the first occurrence and delete the other rows.
So i.e. 700001 has 4 amounts they total 65.00 so replace 15 [first amount] with 65.00 and delete rows with 20, 25 and 5. Then do this for all other codes starting with 7 in column ‘C’
17/08/2016 700001 15
17/08/2016 700001 20
17/08/2016 700001 25
17/08/2016 700001 5