All, I need help writing a macro that will find and delete rows within a table with specified critetia located in multiple columns.
Here are the report details.
Workbook is titled "Red", WS is titled "Blue".
The criteria is located in multiple columns and Column K is the only column with multiple criteria within that column.
Criteria1 - Col "L" - "K"
Criteria2 - Col "K"- <> "01", "02", "03"
Criteria3 - Col "AG" - "LIGHT"
As a side note, this report is dynamic in rows but never columns. the column range is "A:AH"
Any help is greatly appreciated. TIA.
Bookmarks