Highlight the Dupicates from two work sheets

[balasubramani]

Hi to all....
Am a new person to Excel macro. my prob in excel find out the duplicates from two excel sheet.
In my sheet1 have Lot of customer names and them Area in a Column A and B.Then my sheet2 have customer name and them Area in column A and B.The Sheet2 data are existing in my database. What i want do in my find and highlights the duplicates in sheet1 from sheet 2. what are customer name and them area same in sheet1 and sheet2 display in column c as a "Duplicate" in Sheet1.only matching customer name alone display column c as "Non dupliactes"
i want do lot of data with in less time period so kindly help to me..
Thank you
Bala.

 

[WinteE]

Hi Bala,

Instead of using a macro you could consider to use 'Conditional Format'. Instead of creating an extra column in sheet you can highlight the duplicate names this way.

Select the first cell in the list of names and select from the menu <i>Format, Conditional Formatting ...</i>. Instead of 'Cell value is' you have to select 'Formula is', now you enter a vlookup function to lookup the name in the current cell in sheet2.

To highlight the cell A2 when a duplicate is found on sheet2 you should enter =VLOOKUP(A2,Range on sheet2,1,0).

Success,
Erik