Excel 2007 : merging data

[jschorn0]

I have an excel database that use as a core for monthly accumulated points, i import data from .csv text file and the import adds new entries for the same people. Currently i have to add each entry together by hand, is ther a way to merge the data via macro/plugin/etc.

Example

Player 1 | 47 |
Player 2 | 12 | (old data)
Player 2 | 14 | (imported data)

Needs to read

Player 1 | 47 |
Player 2 | 26 |
Player 3 ...


I hope this makes sense and someone can help me

[JBeaucaire]

Yes, this would be simplest with a good excerpt of an actual workbook UPLOADED so I can test this macro. I've done several "Consolidate" macros, and each requires knowing exactly the format of the incoming data. So, here's a version that assumes all the data is in columns A and B with labels in row 1 and data starting in row 2. If that's not true, click GO ADVANCED and use the paperclip icon to upload a real workbook.

Please Login or Register  to view this content.

[jschorn0]

__DJ_Phantom_1 16
__JoyceAnne__ 21
__XG__WebMaster 33
_3M_Baby 35
_3M_Baby 65
_3M_Baby 139
_3M_DirtyDice 26
_3M_KewlWhip 39
_3M_Mrs_O 26
_3M_Oxford_MD 53
_3M_Oxford_MD 3
_Antoinette_ 23
_Antoinette_ 2
_Antoinette_ 8
_Antoinette_ 21
_Smack_Zilla 5
_Smack_Zilla 38
_Smack_Zilla 33
AAB_GooberPea 3
AIF_RO_Cristina 1
aif_skippy5 1
airraid 1
American__Girl 9
angashore 1
angashore 21
Angel1TX4 1
Annie_USMC 9
Anterico 1
army20bln 9
arto_d2 1
arze_i_nick 1
Baa_Lambieee 56
baby_girl848 33
baby_girl848 3
ballyhoo99 31
Baroo 1
bearclaw36 1
BHS_BaddBaddMan 9
BHS_IceCube 9
bhs_snookie 2
BHS_SweetLilPup 6
BHS_WildHeart 5
BibbedXbot 3
BibbedXbot 59
bigpav17 3
billad 5
billad 25
BOMMELY 17
BOMMELY 4
BOMMELY 1
Booo 1
Booo 71
Booo 42
bpt_coach1 1
bpt_coach1 3
Brs_Edu2 7
Brs_Edu2 33
Brs_elisabete 67
BRs_Puff 37
bullybeef 24

[jschorn0]

here is the uploaded example you asked for

[JBeaucaire]

This is a better macro now that I actually see the real data. Start with a workbook next time...hehe.

Please Login or Register  to view this content.