Delete rows from one sheet containing deatils on the second sheet

G

Guest

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.
 
G

Guest

Please don't multi-post. See response to your identical postings in
microsoft.public.excel and .worksheet.functions

---
 
G

Gordon

[email protected] said:
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.
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting rows from one sheet based on 2nd sheet 1
filtering rows depending on onother sheet 3
extracting unique records 1
VBA to automatically cut, paste entire row based on date input and delete row 0
copy data from master sheet new 2
Match and delete rows on two different sheets from reference numbers 4
Auto Copy Data from one worksheet to another 1
data to summary sheet for a dummy 0

Top