Worksheet compare?

[Deborah Mowry]

I have a column with Items sold (listed in alpha order by the item number)
along with description, quantity, price etc.
Another month, I am sent another worksheet listing Items sold that month.
They want me to compare the two worksheets - What was sold in both months
and another answer as to what was not sold.
Can I do this? In Word I would look for a document compare to find out what
was different between two releases of a file. I am hoping there is something
similar in Excel.
Many thanks,
Deborah

 

[Peo Sjoblom]

No there is nothing similar, you can use VBA
and download compare written by Myrna Larson & Bill Manville

http://www.cpearson.com/excel/download.htm

You can also use formulas

http://www.cpearson.com/excel/duplicat.htm