Using VB to get only those records that match values from a long(2000)list
 

I have a CSV excel file, it has about 7000 rows.with 65 fields. There
is field in it called PLAN NAME. I have a separate list of 2000 PLAN
NAMES. What i want is to delete all rows(same worksheet or different)
that match the the PLAN NAMES.
For instance
PLAN NAME has NPPA002.
and there are 3 rows that have this plan name, the resulting worksheet
should delete these three rows and give me the rest. I can use filter
but it doesn't work because i'm looking against 2000 plan names,
amongst which if it finds any of them, it deletes it.
Any help will be very much appreciated.


--
mmamin
------------------------------------------------------------------------
mmamin's Profile: http://www.excelforum.com/member.php...o&userid=20768
View this thread: http://www.excelforum.com/showthread...hreadid=396073