Check cell content from one row to second row and put unique values in 3rd row

I get lot of domains and My job is to find contact info for all these domains. I am attaching one excel file. There are 3 rows, one master url , new url , unique urls. Let me explain what these names mean

1) Master url - I have already found contact info of 3000 websites. All these urls lie in master url row.
2) New url - I found new urls, websites which are new and might need my company's help. I need to find contact info of these sites, but first I need to remove duplicate urls from this list.

Now, Obviously "new urls" lot of times contain urls for which I have already found contact info. Last time, I found 2000 contact infos and around 1500 were duplicated. My boss was very upset with me. I want a way, in which if I put new urls in "new url" row. I should click a button or run a vba script, it should put unique urls in row 3 (unique urls). Can someone help me please.

Try this.

Please Login or Register  to view this content.

Everything in the second column already exists in the first column, therefore you get no results in the third column.

This version might be faster. If you have a large data set you may want to test both versions of the code and see which is faster.

Please Login or Register  to view this content.

Thanks for the rep. points.

Please click the Thread Tools drop down box above your first post and choose solved.