Content Comparison

...

1. Order cancelled
   1. master tab
      1. Leave row highlighted and make text red to indicate cancelled title
   2. sierra tab
      
      1. delete row
2. Order fully paid (monographic order) used serial fund code (sierra tab most likely)
   1. Delete the row
3. Order is valid (sierra tab)
   1. Add title to the bottom of the master  tab, we'll fill in the additional data later, and highlight those lines in light green on both tabs
4. Order Type is w/Comp Sub and w/Other Sub (sierra tab only)
   1. These can be deleted
5. Order indicates it's part of a System deal (see Order Code 3)
   1. These can be deleted from the list as well as well
6. Fund code on order doesn't match or is multi (master tab most likely)
   1. Update fund code if it changed on master tab and highlight the row pink

So in our example collection one of the order can be removed since it falls into Scenario #2 from above, and one will be added to the master tab since it falls into Scenario #3. The title marked On Order should have actually been cancelled so it's status was changed and it was removed from the sierra tab.  If you are not sure what to do with a title just leave it highlighted and I'll review it, you can also add notes in last column.

...