G
Guest
I have 2 sheets - first contains contact detail - first_name, last_name,
email, company, job_title, street_no, street_add1, etc., etc., etc., The
second contains a list of email addresses (only) which bounced back during
the last 3 months.
I wish to :
1- extract all the contacts which have valid emails into a new sheet, and
2- extract all the contacts which DO NOT have valid email addresses into a
new sheet.
Ive been trying to make a macro, trying different filter criteria, but I
just dont get it.
Any help much appreciated.
mark
email, company, job_title, street_no, street_add1, etc., etc., etc., The
second contains a list of email addresses (only) which bounced back during
the last 3 months.
I wish to :
1- extract all the contacts which have valid emails into a new sheet, and
2- extract all the contacts which DO NOT have valid email addresses into a
new sheet.
Ive been trying to make a macro, trying different filter criteria, but I
just dont get it.
Any help much appreciated.
mark