Home How to merge and sum using excel vba
Reply: 0

How to merge and sum using excel vba

user1060
1#
user1060 Published in July 21, 2018, 11:28 am

Im trying to create vba to merge the text value and sum the amount. For example I have below data

Date         Name            Type       Amount
1 Jan        Test1            A           100
1 Jan        Test1            A           150
2 Jan        Test1            A           110
2 Jan        Test1            A           200
1 Jan        Test1            B           130
1 Jan        Test1            B           110
1 Jan        Test2            B           130
1 Jan        Test2            B           160
1 Jan        Test3            B           180

The result should look like this

Date         Name            Type       Amount
1 Jan        Test1            A           250
2 Jan        Test1            A           310
1 Jan        Test1            B           240
1 Jan        Test2            B           290
1 Jan        Test3            B           180

I have try to use below vba but does not seem to work How to SUM / merge similar rows in Excel using VBA?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.309267 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO