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!