I have a worksheet consisting of approximately 50,000 rows and 30 columns (A - AD). Each column has a heading. I need a macro that will quickly delete all rows that don't contain specific text in Column C. Column C will have names of schools, elementary, middle, and high. There are approximately 225 different school options to go in each row in Column C. For each macro, I will designate 35-45 schools to keep, with all other rows being deleted. ols. Let's say that for this example, I would like to keep all rows that contain any one of the following schools in Column C (SchName): Happy Valley Elementary; Rolling Thunder Middle; Betsy Ross High; and John Glenn High.
<tbody>
</tbody>
Lev | SchID | SchName | ID | FName | LName | Grade | Gender | Ethnic | Elig |
1 | 1 | Happy Valley Elementary | 1234567 | Humpty | Dumpty | 3 | |||
2 | 2 | Rolling Meadow Middle | 2345671 | Tom | Cat | 8 | |||
3 | 3 | Tuckman County High | 3456712 | Jerry | Maguire | 10 | |||
4 | 2 | Rolling Thunder Middle | 4567123 | Buzz | Light-Year | 8 | |||
5 | 4 | Tuckman County Middle | 5671234 | Peter | Brady | 7 | |||
6 | 5 | John Glenn High | 6712345 | John | Glenn | 12 |
<tbody>
</tbody>
Last edited: