Hi
I had this macro that compared data between sheets 1 and 2 and marked "OK" "MISSING" and "DUPLICATE"
What im trying to amend it to do is to mark "OK" and "DUPLICATE" on sheet 1 still but when data is on sheet 2 but not on sheet 1 I need it marked "MISSING" on the row concerned on sheet 2...