I need a macro for comparing 2 columns. I have two workbooks, and want to compare the specific column from 1st workbook, sheet3(Column D) with next work book,sheet2 (column C). After comparison highlight the matching cells in 1st workbook. Can someone please help me on this?