Comparing worksheets

[Guest]

I have two large worksheets with 1000+ rows and 18 columns. I want to compare worksheets to find out what does match between the two. Any ideas how I can do this?

 

[Guest]

Looks like your out of luck. No one seems to know how to compare worksheets.

 

[NickHK]

Gabriel,
One way would be to set up a 3rd sheet, whose formula for all relavant cells
is something like:
Cell A1: =IF(Sheet1!A1=Sheet2!A1,"Match","Different")

Or alternatively loop through the sheets comparing values in code:

If WS1.range(i,j).value=WS2.range(i,j).value then
'.........
Else
'.........
End If

You would then have to decide what to do with these results.

NickHK

I have two large worksheets with 1000+ rows and 18 columns. I want to

compare worksheets to find out what does match between the two. Any ideas
how I can do this?

 

[Frank Kabel]

Hi
you may have a look at

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla (http://www.cpearson.com/Zips/Compare.ZIP)

also Bernie Deitrick produced a really nice macro to compare two
worksheets.