Trying to delete rows with a macro. First criteria is that text in a cell does not start with GE WEST and the second criteria is to delete the row if the text in cell D is equal to the Text in Cell A2 on another sheet.
Example included as this is hard to explain.
Edit: The attached example only has a few rows but the working file could have many thousands.
Thanks in advance,