Dynamic sum of rows

**nia_manuel** · 03-09-2009, 02:58 PM

Hi All,

My .csv incoming file has data as follows
Company_name Company_Code Amount
ARS 001 32
ARS 001 54
ARS 002 11
PPP 123 10
PPP 123 54
ASP 555 22

I want to get the sum of amount based on company name and company code
The number of rows can change all the time .i am new to VBA .Any help is appreciated.I want to write a macro for this .the out file should be like this
Company_name Company_Code Amount Sum
ARS 001 32
ARS 001 54 86
ARS 002 11 11
PPP 123 10
PPP 123 54 64
ASP 555 22 22

**Shijesh Kumar** · 03-09-2009, 03:00 PM

Try to use pivot table......
Easy and more efficient...

**Tarball** · 03-09-2009, 03:12 PM

A pivot table is your best bet but if you do not want to use one then you can use Array formulas and named ranges. These are generally easy to use and will do the trick.