Consolidate row based on value

**Ssammy** · 05-24-2013, 01:04 PM

Hi,

Im looking for an example of a macro in which...

searches on column D for same values

and on columns H write the consolidation of column D.

I attached an example of the data in which the idea is more clear, I think

thanks,

Sammy

**arlu1201** · 05-24-2013, 02:20 PM

Did you try subtotals ?

**AB33** · 05-25-2013, 06:58 AM

It can easily be handled by a Pivot Table, but if you want a code, the output is in new sheet.

**Ssammy** · 05-27-2013, 09:07 AM

Hi,

works great!

Thanks a lot.

Sammy

**arlu1201** · 05-27-2013, 09:10 AM

Since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.