Sum amount based on same reference id using VBA

**djfscouse** · 02-15-2013, 06:22 PM

Hi,

If I have a excel 2003 file with a few rows/columns as follows

ColumnA,ColumnB,ColumnC
1234B,AB900,1
1234B,AB900,1
1244A,AB901,1
1267B,AB906,2
1279B,AB915,1
1279B,AB915,3
1279B,AB915,1
1288A,AB922,2

Is it possible to create a new line above each group of column A id and enter the total of column C using VBA relevant to the column A id as shown below.

example after conversion:

2
1234B,AB900,1
1234B,AB900,1
1
1244A,AB901,1
2
1267B,AB906,2
4
1279B,AB915,1
1279B,AB915,3
1279B,AB915,1
2
1288A,AB922,2

Thanks for any help,

David

**Alf** · 02-16-2013, 07:31 AM

Assuming that you data start in cell A1 you could try this macro.

Please Login or Register  to view this content.

Alf

**Alf** · 02-17-2013, 03:20 AM

Hi David

Thanks for rep!

Alf

**Alf** · 02-17-2013, 07:26 AM

Hi David

Checking the macro I wrote I found it does not work right if the 3 first (or more) values in the A column are equal so I've written a fix for that. Do a test and see if you can find any problems.

Please Login or Register  to view this content.

Alf

Sum amount based on same reference id using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Sum amount based on same reference id using VBA

Re: Sum amount based on same reference id using VBA

Re: Sum amount based on same reference id using VBA

Re: Sum amount based on same reference id using VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions