Difference between 2 worksheets

[johnb]

I have 2 large worksheets 10,000+ rows with 20 columns. I
need to find the values missing on sheet1 compared to
sheet2. And then compare sheet2 with sheet1. How do I
attack this problem?

TIA johnb

 

[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)