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.

Here's a quick fix you could apply using formulas ..

Source data is assumed in Sheet1, cols A to H (say),
data from row2 down, with email addresses in col C.

Bounced email addresses are assumed listed in Sheet2, in A1 down

In Sheet1,
Using an empty col to the right, say col X

Put in X2:
=ISNUMBER(MATCH(C2,Sheet2!A:A,0))
Copy down to the last row of source data, X900? Then select col X, click
Data>Filter>Autofilter. Select: TRUE from the autofilter droplist in X1. This
filters out the rows to be deleted. Select all the filtered rows (select all
the blue colored row headers), then right-click > Delete Row. That's it.
Remove autofilter, and you would have your residual list, trimmed of all the
bounced email in Sheet2.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"(E-Mail Removed)" wrote:
> 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.
>