Matching Two Lists and deleting the Macthed columns

Hello everyone can you please help me with my problem, how can i Compare two lists Containing each email addresses and Delete the matched Emails addresses from the first list, the main list is L1 and the second list in L2 which contains the emails that should be taken off from the Main list. in other words my list contains email addresses which doesn't exist anymore ( Hard bounce ) i managed to collect those emails that doesn't exists,deleting them one by one from the main list isn't something easy to repeat 500 Times. I'am not good VBA codes. Thanks you picture.jpg

Hi.
Be sure to enable the macro when the worksheet that contains the data is the active worksheet.

The macro will look up the data from column "C" in column "A" and will erase this data from column "A" by moving the cells upwards as it deletes.

Please Login or Register  to view this content.