Search Cell Value Delete if Not in Named Range

Originally Posted by stnkynts

1. What is your named Range called and what sheet is it on?
2. Exactly which sheets do you want to compare column K to the named Range?
3. Do you want to delete the row of column K when it does not match anything in the named range OR do you want to delete the row of the named range if it does not match anything in column K?
4. Are there any other sheets that will have nothing to do with this? (dont want to set a macro to work across all sheets if it needs to be specific)

1. The named range is called "TABMODELS"
2. Sheet3 i want to compare column J to the named range, Sheet4 & Sheet5 I want to compare column K to the named range.
3. I want to delete the row of column K/J when it does not match anything in the named range.
4. There are other sheets in the workbook, so it does have to be sheet specific.