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.
Max - 06 Sep 2007 07:50 GMT
Please don't multi-post. See response to your identical postings in
microsoft.public.excel and .worksheet.functions

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
magold2005@hotmail.com - 06 Sep 2007 08:54 GMT
Hi Max,
Aplogies for multi-posting.
Your suggestion works fine
thank you
Mark
> Please don't multi-post. See response to your identical postings in
> microsoft.public.excel and .worksheet.functions
Max - 06 Sep 2007 11:10 GMT
welcome, Mark. good to hear that.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Hi Max,
>
[quoted text clipped - 4 lines]
>
> Mark
Gordon - 06 Sep 2007 07:51 GMT
>I need help - please:
>
[quoted text clipped - 13 lines]
>
> All help appreciated.
Firstly can I ask why the email addresses are on a separate sheet?