| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete all rows except those meeting criterias
Headers on row 1.
Data in A:AD Criteria in column B. Delete rows if the value in row B does not equal "Apples" or "oranges" Then create sheets based on value in A, and copy the data onto each sheet based on the data in A and the name of sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows meeting certain criteria in a particular column | Excel Discussion (Misc queries) | |||
| Code to delete columns meeting a condition | Excel Discussion (Misc queries) | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
| Delete Row meeting a Criteria | Excel Programming | |||
Threaded Mode
