Ok, so I can't figure out how to do this at all. I basically have a spreadsheet with varrying number of rows. I want to check the value of a specific column (K) and if the value of that column is not in my named range I want it to delete the entire row. Currently I am using a lot of macros like...