| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows at end of sheet | Excel Discussion (Misc queries) | |||
| Find & delete rows with ID's from another sheet. | Excel Discussion (Misc queries) | |||
| Sheet is blocked when I try to delete more than 5 rows | Setting up and Configuration of Excel | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
Linear Mode
