filtering rows depending on onother sheet
I need help - please:
I have 2 Excel sheets:
1 €“ Contains all contact details (aaprx 900 rows)
2- Contains email addresses which have bounced back over the past 3 months
(approx 80 rows)
Sheet 1 - first_name, last_name, email, company, job_title, street_no, etc,
etc, etc.,
Sheet 2 €“ email_address
How can I write a macro or function to delete the rows in sheet 1 that
contain the bounced email addresses listed in sheet 2
All help appreciated.
|