Comparing two Excel Sheets Automatically

[fbacchus]

Hi,

I have 2 Excel Sheets with the same columns and formats that I would like to compare and end up with two new sheets (1) containing only the unique records derived from both sheets and (2) another sheet with the duplicate records, identifying the cells that caused the duplication. I've tried the Advanced Filter functon but this just created the unique records. I do not know which were the duplicate records and which columns caused the duplication. Is there a way to do this with a macro ?

Thansk in advance

frank

 

[nisht]

You can do this by downloading a small utility from my website..

http://www.pexcel.com/download.htm

name of the file is comparerange to compare the two range.

and to find duplicate you can download the file

findduplicatevba


it is the last file.

ni****h desai
http://www.pexcel.com