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.
|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|