We use Excel 2013 and need some code that will remove emails from selected column if they appear in a chosen tab.
1. Click on column with email addresses and run the 'Scrub against Blacklist' code.
2. This shall prompt for the tab with the bad email addresses to be chosen.
3. Once run, the rows on which the bad email addresses appear will be removed.