Compare fields and if match found move data and delete row

I need a vba solution for the following:

I have a spreadsheet where I need to compare fields in columns A & B and if they match one another then remove the duplicates but put the data from the duplicates in columns d & f. I have attached an example of what I am looking for. Any help would be appreciated.


[attach]example.xlsx[/attach]



Thanks,

Met

Try

Please Login or Register  to view this content.

Thanks that did it.

Met