remove duplicated row and increase weight columns with vba

I'm trying to add a weight for source and target cell...so I do this :

Please Login or Register  to view this content.

then the result is like this :

Please Login or Register  to view this content.

But I didn't want to show the duplicates row (source and target) i want to remove the duplicate and increase the weight ...
like this :

Please Login or Register  to view this content.

any help for that ??

thanks

Hello fifohsn,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.