Remove emails from selected column if they appear in a chosen tab.

We use Excel 2013 and need some code that will remove emails from selected column if they appear in a chosen tab.

STEPS:
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.
frugalmuleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
what is the sheet name where the emails to be removed from?  what is the column in which the clean up to be done?

in sheet bad email address, what is the column in which the bad email addresses are located?

can you upload a sample file?
0
frugalmuleAuthor Commented:
It should request for those to be selected
0
ProfessorJimJamCommented:
please find attached.

simple run the macro of "ScrubagainstBlacklist"  it will delete all of the emails in "Whitelisttobecleaned" Column A which is found in "BlackList" column B of Bad emails.
EE.xlsm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

frugalmuleAuthor Commented:
Thanks, but doesn't meeet request.  Columns and tabs cannot be predefined.
0
ProfessorJimJamCommented:
You can pre define them, open the workbook press alt f11 then click on module1

You can see the code there

You can change the sheet name and column name from there
0
frugalmuleAuthor Commented:
My code repository system doesn't allow me to save the file, only the code, which is why it is necessary that it function the way I intended where the code itself prompts me to select the column, of emails, and select the tab the contains the blacklist.
0
ProfessorJimJamCommented:
Ok. if you insist with the inputbox option, here it is attached.

download the attached file. and then press in Keyboard Control + k and the macro will run and it will ask you to select the first cell of whitecell column and so you click on the whatever column of your sheet that has your whitelist emails and then it will ask you for the badlist , so select the first cell of whatever column and sheet that has your badlist of emails once you did that then you will see that whitelist will be automatically cleaned from the values that were found in badlist.

I tested it and it works perfectly.
EE.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
frugalmuleAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.