Delete Rows based on an external list
 

I have a large worksheet with customer data (one customer = one row). I
would like to delete the entire row for those customers that do NOT appear on
a list found in an external Excel workbook.

NOTE: While this list is held externally, I could paste it into another
worksheet within the customer workbook -- if that makes it easier....

Any thoughts? TIA!

Delete Rows based on an external list
 

Hi Jeff,

See 'Extracting Values on One List And Not Another' on Chip Pearson's
Tagging Duplicates page at:

http://www.cpearson.com/excel/duplic...gingDuplicates

---
Regards,
Norman



"JEFF" wrote in message
...
I have a large worksheet with customer data (one customer = one row). I
would like to delete the entire row for those customers that do NOT appear
on
a list found in an external Excel workbook.

NOTE: While this list is held externally, I could paste it into another
worksheet within the customer workbook -- if that makes it easier....

Any thoughts? TIA!

Delete Rows based on an external list
 

Jeff,

Use a helper column to identify not founds, using say MATCH into the other
list, and then filter this column on the not found value, then delete
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JEFF" wrote in message
...
I have a large worksheet with customer data (one customer = one row). I
would like to delete the entire row for those customers that do NOT appear
on
a list found in an external Excel workbook.

NOTE: While this list is held externally, I could paste it into another
worksheet within the customer workbook -- if that makes it easier....

Any thoughts? TIA!