Hi all,
I've come to a problem that I can't figure out and humble ask for some guidance. I'm not sure how to best describe what the report is but I can describe what I need it to do. I want the macro to:
compare E2 to E1
If E2/E1 match, then compare D2 to D1
If D2/D1 match then go to the next line and compare E3 to E2
If D2/D1 don't match, delete row 2.
If E2/E1 don't match, then go to the next line and compare E3 to E2
I want this to run on every line all the way through to the end of the report. I feel like this should be easy to program but I'm new to vba and most of what I've learned has been by doing it in a macro then reverse engineering it. Thanks so much for the help!
Example.xlsx
Bookmarks