Compare two columns in different workbook

[moorthy24]

I would appreciate if I can get help in creating this macro. I have two workbooks, and want to compare the specific column from 1st workbook, Ex: Column H with next work book, Ex: column A. After comparison highlight the matching cells in 1st workbook.

 

[rondeondo]

Hi Moorthy
an option is to add a column to the first workbook and put in

=ISNUMBER(MATCH(h1,[wb2.xlsx]Sheet1!$A:$A,0))

then use conditional formatting to highlight where this new column has true. If you want a macro because you want to do this often, you could probably record one.
I do this process quite frequently, it really is very quick.