How to combine data and delete rows
 

I have a spreadsheet with thousands of census data entries and I need to
combine multiple entries based on a social securtity number. An example
is below. I need to combine the contribution colum and the rest of the
info can remain the same while deleting the duplicate entry. Some
people may have more than 2 entries. Can anybody help with a macro
program. Thanks.

Ss# Name contribution Comp Birth date Hire
date
55555555 Doe, John 38.10 508.00 01/01/45 11/01/98
55555555 Doe, John 35.00 508.00 01/01/45 11/01/98
66666666 doe, Jane 22.50 300.00 03/01/60 02/15/06


--
PARSguy
------------------------------------------------------------------------
PARSguy's Profile: http://www.excelforum.com/member.php...o&userid=36638
View this thread: http://www.excelforum.com/showthread...hreadid=563915

How to combine data and delete rows
 

Why not create a pivot table from this data in order to sum the
contributions... that is a whole pile easier and more flexible than code...
--
HTH...

Jim Thomlinson


"PARSguy" wrote:


I have a spreadsheet with thousands of census data entries and I need to
combine multiple entries based on a social securtity number. An example
is below. I need to combine the contribution colum and the rest of the
info can remain the same while deleting the duplicate entry. Some
people may have more than 2 entries. Can anybody help with a macro
program. Thanks.

Ss# Name contribution Comp Birth date Hire
date
55555555 Doe, John 38.10 508.00 01/01/45 11/01/98
55555555 Doe, John 35.00 508.00 01/01/45 11/01/98
66666666 doe, Jane 22.50 300.00 03/01/60 02/15/06


--
PARSguy
------------------------------------------------------------------------
PARSguy's Profile: http://www.excelforum.com/member.php...o&userid=36638
View this thread: http://www.excelforum.com/showthread...hreadid=563915