Hi,

I use MS Excel to record all of my back link data for SEO campaigns I run. Some of the links though get taken down so I have to run regular live link reports to make sure the data is up to date. The live link data includes the back link, the page on the site it links to, the anchor text of the link and the status of the link (either found or not found). I also record the username and passwords for the links i have created and the type of link so that i can change any links if i need to. The difficulty with this though is removing the links that are no longer live to keep the spread sheet up to date without removing all of the other data. Is there a way of importing a list of links that i want removed from the spread sheet in bulk?

Would pasting the links not found above the main list and removing duplicates work, and then highlighting the not found links work? Is there an easier way?

Thanks in advance for any help