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" <JEFF@discussions.microsoft.com> wrote in message
news:38463FB6-083D-4BDA-97FE-9178991B4150@microsoft.com...
> 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!