Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding rows depending on cell value | Excel Worksheet Functions | |||
hiding rows depending on the date | Excel Discussion (Misc queries) | |||
Merge Rows depending on value of the first column | Excel Worksheet Functions | |||
Extracting rows depending on string | Excel Worksheet Functions | |||
How to delete a set of rows depending on Value | Excel Discussion (Misc queries) |