Hi

I have data in two sheets (sheet1, sheet2). I would like to compare values in column A between sheets and find all rows that there is no match based on column A

However, the number of rows between the sheets differ and the data is not arranged in the same order. So I need to compare the first populated value in sheet 2 (“a2”) against all rows populated in column A to see if there is match and if not highlight that row in sheet 2 and then do the same with a3, a4 etc.

End Sub

Is this possible to do?