Hello . . .

I would like to compare two columns of data, against each other, usin
visual basic for Excel.

I have four columns: A, B, C, & D.

Columns A and B have the initial data. Columns C and D will have th
resulting data.

Columns C displays a message "OK" if the data in cell B1 is found
anywhere in column A. This is also true for cells B2, B3, and so on .