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.