How to combine data and delete rows

[PARSguy]

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

[Jim Thomlinson]

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
>
>