View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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!