Compare two workbooks sheet1 column A

[farrukh]

HI All,

I need a code that compare1.xls with compare2.xls sheet1 column A , but without opening the compare1.xls and get the result in compare2.xls tab sheet2.

Thanks
farrukh

[farrukh]

HI All

More description about code...

I have two workbooks suppose compare1.xls and compare2.xls ,in both workbooks sheet1 columnA i want to check the similarity of content (name). if does not find similarity in any row column A the highlight the row with any color.

Thanks
farrukh