VBA to merge duplicate rows and sum values

MrTD

New Member
Joined
Feb 12, 2020
Messages
4
Office Version
2016
Platform
Windows
Hi all,

I found this previous thread that is similar to what I need but haven't had joy with any of the codes provided (super noob in the world of VBA).

I need to merge different Excel sheets, where column A, C & D are exactly the same. If this is true then the values column (F) should be totaled and merged to make one row of data. The remaining cells not mentioned can be the same and aren't too important. I've used Power Query to merge multiple sheets and append so all appear in one document (if there is a better way to do this then open to suggestions). Just need help with this part.

Excel VBA help.JPG


Any help would be greatly appreciated.
 

MrTD

New Member
Joined
Feb 12, 2020
Messages
4
Office Version
2016
Platform
Windows
Thanks sandy but there will be hundreds of different variations. Was hoping that somebody had a code that would make this process more efficient?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,188
so your description isn't clear enough
try again
 
Last edited:

MrTD

New Member
Joined
Feb 12, 2020
Messages
4
Office Version
2016
Platform
Windows
Apologies, I'll start a new thread. Cheers
 

MrTD

New Member
Joined
Feb 12, 2020
Messages
4
Office Version
2016
Platform
Windows
Wasn't aware of this function, worked a treat. Thanks
 

Forum statistics

Threads
1,085,181
Messages
5,382,167
Members
401,779
Latest member
Thonor

Some videos you may like

This Week's Hot Topics

Top