how check 2 columns, making sure 1 column as not missed any thing from column 2

[Melville]

Hi,

I have 2 columns and im trying to check if column 1 has all the data included from column 2.

How would i carry out the check.

thanks

[pike]

Hi Melville,

One way ....

Sub tester()
Dim cel As Range
For Each cel In Range("A1", Cells(Rows.Count, "A").End(xlUp))
 If Not cel.Value Like cel.Offset(0, 1).Value Then
 cel.Offset(0, 1).Interior.Color = vbRed
End If
Next
End Sub