| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing duplicate records with long names in Excel 2007 | Excel Discussion (Misc queries) | |||
| How do I match values from cells to a list of info | Excel Discussion (Misc queries) | |||
| PRODUCE A PRODUCT THAT WILL LIST A STRING OF VALUES FOR A MATCH | Excel Worksheet Functions | |||
| Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
| Make Excel 2000 print long narrow list "snake" on wide paper? | Excel Discussion (Misc queries) | |||
Threaded Mode
