Macro to combine Rows

Hello,

I was hoping someone could provide me with a Macro to solve the following problem:

I have a table which has employee names on the left handside. Next to them are contacts in a region.

Please Login or Register  to view this content.

What I need to do is to combine the data for the employees that have been duplicated and leave the non-duplicates as is. That means for example there should only be 1 row for Sarah and Doug with the values in the duplicate row added together.

So when the macro is run the table should look like this:

Please Login or Register  to view this content.

I hope I have explained this clearly. All help is appreciated.

Thanks

Why a macro?

You could list the unique employee names in a column, and use SUMIF formulas to tote the contacts in each region.

Please Login or Register  to view this content.

The formula in B9 and copied down and across is =SUMIF($A$2:$A$7, $A9, B$2:B$7)

THANKS SHG!!!!!!

It looks like it worked!!!

Please mark thread as SOLVED?