| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete row that contains keyword
Looking to clean up a list of items by deleting certain unneeded data. The
lines I want to get rid of contain certain keywords. How (with VBA) can I delete those rows? Example: (have now) LN QTY Description 8 1 Panelboard, Type AE (101) 13 20A 1 Pole TEY 17 20A 1 Pole TEY Space 6 20A 2 Pole TEY 1 Copper Bus Heat Rated 1 Nameplates 1 Ground main lug TGL20 4 Ground-Box bonded TGL2 1 AB43B Box 1 AF43SN Front 1 AEF3422MBX Interior AXB7 Example: (want) LN QTY Description 8 1 Panelboard, Type AE (101) 1 AB43B Box 1 AF43SN Front (keywords were "interior, ground, nameplate, pole, copper") Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a keyword from cells | Excel Discussion (Misc queries) | |||
| keyword search and delete row | Excel Discussion (Misc queries) | |||
| search by keyword | Excel Discussion (Misc queries) | |||
| SQL Keyword | Excel Programming | |||
| Delete Rows above keyword | Excel Programming | |||
Threaded Mode
