I want to compare two worksheets to generate result if found duplicate.. attached sample.xls sheet("report") show the required data..
we only have to compare Cus sheet column F with Emp Sheet column G and get the employees details..
Any help using formulas or macros will be highly appreciated..
Bookmarks