Merge duplicate rows and sum values

[Metrazal]

Looking for a VBA script to merge data in columns A:D if they are duplicates and sum column E. See example.

Starting point

Sample 1.png

Final

Sample 2.png

Any help would be appreciated.

Thanks,

Met

[Marc L]

As we do not have any data neither a rules explanation …

[Metrazal]

I apologize. See attached.

Thanks,
Met

[Fluff13]

How about

Please Login or Register  to view this content.

[MarvinP]

Hi Metrazal,

See the attached where you can do a Pivot Table and change the "Design" of the table to show what you want. No formulas needed, simply a little changing of Pivot options. See the attached under your answer where I've done a Pivot.

Pivot Table instead of VBA.xlsx

[Metrazal]

Ok. In my large/non sample spreadsheet I get the following error:

Compile error:
Method or data member not found (First Index in 5th line of script is highlighted)


In the Sample spreadsheet I get the following error:

Run-time error 424
Object required (If Rng Is Nothing Then in eight line is highlighted)

Thanks,

Met

[jindon]

Try

Please Login or Register  to view this content.

[Fluff13]

Does it work for you in this file

[Metrazal]

I was able to utilize Jindon's script to achieve the desired results. Thanks to everyone for the quick responses.

Thanks again,

Met

[Metrazal]

Fluff13:

Yours works as well. Thanks again for everything.

[jindon]

You are welcome and thanks for the rep.

[Fluff13]

Glad to help & thanks for the feedback