View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicholas Nicholas is offline
external usenet poster
 
Posts: 19
Default Trying to compare worksheets.

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