title: Excel VBA: delete rows if cells do not contain values from a table
body: <p>I have a data sheet with ~50,000 rows. Each row has a location identifier (column C) and other data (columns D-H). I need to delete all rows whose location identifier does not match one of 73 values in another table.</p>
  
  <p>I need to use VBA (rather than formulas/conditional formatting/tables) because I'll need to repeat the action hundreds of times with new sheets.</p>
  
  <p>The closest I've found is "<a href="https://stackoverflow.com/questions/19019304/vba-deleting-rows-that-do-not-contain-set-values-defined-in-range">How to delete all cells that do not contain specific values (in VBA/Excel)</a>". However, the code provided in the answer didn't work. No errors, just nothing happened.</p>
  
  <p>Grateful for any help out there!</p>