PDA

View Full Version : Compare two workbooks sheet1 column A



farrukh
05-30-2011, 10:59 AM
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
06-01-2011, 09:54 AM
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