Hi
I have a table like this :
<tbody>
</tbody>
I Want a macro to remove Duplicate Codes and calculate sum of each codes and copy results to new sheet .
Like This :
<tbody>
</tbody>
I know that i could use Pivot Table but i want to use macro .
Thanks in Advance .
I have a table like this :
A | B | C | D | E | F | G | |
16 | CODE | AMOUNT | |||||
17 | 202 | 100 | |||||
18 | 203 | 200 | |||||
19 | 202 | 200 | |||||
20 | 205 | 300 | |||||
21 | 203 | 500 | |||||
22 | 208 | 150 | |||||
23 | 203 | 100 | |||||
24 | 205 | 500 |
<tbody>
</tbody>
I Want a macro to remove Duplicate Codes and calculate sum of each codes and copy results to new sheet .
Like This :
Code | Sum of Amounts |
202 | 300 |
203 | 800 |
205 | 800 |
208 | 150 |
<tbody>
</tbody>
I know that i could use Pivot Table but i want to use macro .
Thanks in Advance .