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!

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" <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!

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!