Comparing two Excel Sheets Automatically

fbacchus · Mar 15th, 2002, 11:45 PM

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 · Mar 16th, 2002, 12:53 AM

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.

nishith desai
http://www.pexcel.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 11:45 PM	#1
fbacchus New Member Join Date: Mar 2002 Posts: 12	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

Mar 16th, 2002, 12:53 AM	#2
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	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. nishith desai http://www.pexcel.com