View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bugaglugs
 
Posts: n/a
Default Compare two lists of data to find new entries

I currently run a daily report from a CRM database to monitor my sales teams
activities with customers. Each activity has a 'unique' reference.
My aim is to compare the report (which is in excel) from one day with the
new report to show the new 'activities'.
In simple terms I want to say if activity 'x' is in the new list the show
the information from that row on a new worksheet so I can see at a glance the
new activities.