I am trying to write a macro that copies the data from esoms.xls to esomsmacro.xls. It then compares A1 to B1. If they both contain " A" or " B" I want to delete the row. I have this much working. Next I need to see if the same 2 cells both have "A-" or "B-" and delete the row if they do. I think I was going about this the wrong way by deleting the rows that match my criteria rather than copy the rows to a new sheet when they have criteria that I am looking out for. If A1 has " A" and B1 has " B" then I think I should copy that to a new sheet. I need to do this for each row until I come to a blank row. Any help is greatly appreciated and Ill try my best to answer any questions.
ex.
A1 : MT -005- -MT B B1 : 1-MT -GRND -MTB EGRD0002 A
because of the A and B not matching I need to keep these.
here is what i started and started coming to some issues. I have made some of the code into comment to help in my troubleshooting. Thanks in advance:
Bookmarks