Finding Duplicates between different workbook

[Krishna_gopal_2]

I am having three different workbooks having 7-9 sheets. I want to compare 'D' column in between all worksheets and workbooks and highlight them if there are any duplicates. Other column data may be different. Is there any method. Thanks in advance.

[ARGK]

Hi
Have a look at this link which may help you.
http://answers.yahoo.com/question/in...8223047AA1XPxE
Tony

[Krishna_gopal_2]

Hi
Have a look at this link which may help you.
http://answers.yahoo.com/question/in...8223047AA1XPxE
Tony

Here they are dealing with same Workbook. I actually want to check between three different workbooks.