Delete rows from one sheet containing deatils on the second 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.

Delete rows from one sheet containing deatils on the second sheet
 

Please don't multi-post. See response to your identical postings in
microsoft.public.excel and .worksheet.functions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Delete rows from one sheet containing deatils on the second sheet
 

"
wrote in message ...
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.



Firstly can I ask why the email addresses are on a separate sheet?

Delete rows from one sheet containing deatils on the second sh
 

Hi Max,

Aplogies for multi-posting.
Your suggestion works fine

thank you

Mark


"Max" wrote:

Please don't multi-post. See response to your identical postings in
microsoft.public.excel and .worksheet.functions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Delete rows from one sheet containing deatils on the second sh
 

welcome, Mark. good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"
wrote in message ...
Hi Max,

Aplogies for multi-posting.
Your suggestion works fine

thank you

Mark