Duplicate Combine & Add Macro

[Stresbringer]

Hiya All,

I have done some searching and nothing i have come accross quite decribes what i need,.
i hope someone can help me to make some sort of formula or macro which will find duplicate rows and add them together and combine them.Its kind of hard to explain but i will try to show you in my sample data below

ID No Name C D E F
1489 Mike 10 12 100 7
1489 Mike 150 3 100 4
1489 Mike 35 17 100 3

7457 Joe 11 50 200 4
7457 Joe 4 1 200 5

1359 Sue 20 90 150 25
1359 Sue 30 4 150 10
1359 Sue 5 6 150 7

I would like a macro or a formula which will Find the duplicates in a sheet and Combine and add the values together for C, D and F ID Name and E should remain the same.

From the data above result i want to gets is:

ID No Name C D E F

1489 Mike 195 32 100 14

7457 Joe 15 51 200 9

1359 Sue 55 100 150 42

as can see C D and F have been added together but the id and name remain the same, there can be upto 5 duplicated per person so i need to be able to allow for this.

i hope this makes sence

A macro of somesort would save endless hours of work and would cut out much human error, i am new to Vba but i hear you can do pretty much anything with it and i hope someone can tell me if this is possible or not.

Thanks in advance.

 

[Stresbringer]

Perfect !!!

Thankyou jindon your the man

i Just want to say thankyou for all yor time and help, I really appreciate it, i though this was impossible, now you are going to save me hours and hours of time every month

Thanks

Stres.

 

[jindon]

Good!

Hope you can do something else for extra time