Simple compare macro

[Tom44556]

HI.

I need to compare worksheets. Look in data in sheet 1, cell A1, then see if that value exists in sheet 2 column A...if true - shade that cell in sheet 1. If it is not there, go to next row. and compare A2 etc.


Thank you

[raypayette]

Save the workbook as shared.
Click Tools, Compare and Merge Workbooks