need to compare column A in a worksheet with Column A in another worksheet

[blues2000]

hi guys,

is there an easy way to compare Column A in a worksheet with Column A in another worksheet and highlight the same one in the first worksheet?

Thanks in advance for your help.

[AlvaroSiza]

One way: (see my notes in sig for implementation instructions)

Please Login or Register  to view this content.

[blues2000]

Thanks so much for the code Alvaro...
however, I think it stops for searching when it hits a gap in the cell.. there are gaps in the first sheet, so, can we get rid of that?
thanks soo much in advance..