ExcelBanter - Trying to compare worksheets.

"Nicholas" wrote:

I have a worksheet that has yesterday's sales information by item. I receive
another worksheet that has today's sales numbers by item in it.
A unique record is made up of 3 columns A,B,C.

I need to find the following:
1. I need to find out if a new record has been inserted (that doesn't
exist on yesterdays worksheet).
2. I need to find out if the unique record has a match
3. I would also like to know what records have been deleted from
Yesterday's Sales information.

Thanks