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.