Macro to delete/mark criteria based on user selection

Hi all,

I have a 2010 worksheet (example attached) which contains 1000s of email addresses with other personal information. I have a macro which cleans the data up to a point and now I need it to clean the email addresses. What I need the macro to do is:

1. Find and extract all the gmail addresses and ‘present’ them (somehow) back to the user
2. The user would then manually scan the gmail addresses for spam ones and delete the row or mark them as spam
3. Then the macro would resume

The way I thought it could work is that each gmail address would be shown to the user in a small userform, one by one, with two buttons – “genuine”, “spam”. The user would click a button and this value would then be placed at the end of the relevant row for that email address and it would then show the next one and so on and so on.

Then I could easily filter on the spam ones (this bit I can do).

Thanks in advance.

Maybe:

Please Login or Register  to view this content.

Hi yudlugar,

That is truly fantastic. Bravo sir. Thank you.