VBA to merge duplicate rows and sum values

[MrTD]

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.

Any help would be greatly appreciated.

 

[sandy666]

use Group with columns you selected and SUM for value column

 

[MrTD]

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]

so your description isn't clear enough
try again

 

[MrTD]

Apologies, I'll start a new thread. Cheers

 

[sandy666]

you described this

so just do it

why

there will be hundreds of different variations

 

[sandy666]

I'll start a new thread.

not new thread but new post here

 

[MrTD]

Wasn't aware of this function, worked a treat. Thanks

 

[sandy666]

You are welcome
I'm glad you are happy
Thanks for the feedback