Stresbringer
Board Regular
- Joined
- Mar 16, 2006
- Messages
- 84
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.
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.