MACRO/VBA to delete rows based on multiple keyword

%3CLINGO-SUB%20id%3D%22lingo-sub-2280782%22%20slang%3D%22en-US%22%3EMACRO%2FVBA%20to%20delete%20rows%20based%20on%20multiple%20keyword%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280782%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20off%20I%20am%20new%20at%20ALL%20OF%20THIS.%20So%20be%20patient%20please.%3CBR%20%2F%3EI%20have%20a%20document%20that%20starts%20out%20with%20over%204000%20rows%20of%20info.%3CBR%20%2F%3EI%20filter%20and%20delete%20sometimes%20half%20of%20the%20rows%20before%20I%20have%20a%20useable%20document.%3CBR%20%2F%3EThis%20task%20is%20done%20weekly%20so%20I%20am%20looking%20to%20save%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20goal%20is%20to%20have%20something%20that%20will%20automatically%20filter%20and%20delete%20the%20rows%20of%20information%20not%20needed.%3CBR%20%2F%3EI%20have%20already%20tried%20Record%20Macro%20but%20I%20have%20over%20200%20different%20items%20I%20have%20to%20filter%20out.%3CBR%20%2F%3EThe%20attached%20example%20would%20be%20the%20Qualification%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20assistance%20is%20appreciated%20and%20assume%20that%20I%20any%20abbreviations%20or%20%E2%80%9CPro%20Talk%E2%80%9D%20I%20will%20not%20understand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280782%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

First off I am new at ALL OF THIS. So be patient please.
I have a document that starts out with over 4000 rows of info.
I filter and delete sometimes half of the rows before I have a useable document.
This task is done weekly so I am looking to save time.

My goal is to have something that will automatically filter and delete the rows of information not needed.
I have already tried Record Macro but I have over 200 different items I have to filter out.
The attached example would be the Qualification column.

Any assistance is appreciated and assume that I any abbreviations or “Pro Talk” I will not understand.

0 Replies