so create a sheet that i can inject into my report that has each of my terms listed in column A. next have code that searched that sheet and compares it to column A on my current sheet and delete rows that match. After that is run i can then remove the sheet from the report.

I can figure it all out except the code to Search column A on Sheet2 and if it finds a match in Column A on Sheet1 then delete entire row.