title: Show differences between two data sets using a unique identifier through VBA?
body: <p>I have researched this extensively but cannot seem to find a solution. I am attempting to create a macro that will compare data between two tables on different sheets and highlight differences using a unique identifier. </p>
  
  <p>Here is an example:</p>
  
  <p><strong>Sheet 1 (Data Set 1)</strong></p>
  
  <pre><code>UniqueID | Name |  Date  |  Status
  ----------------------------------------
  | 1230 | Bob   | 1/1/2016  | Denied    
  | 6985 | Mike  | 1/6/2016  | Pending    
  | 4442 | Will  | 1/9/2016  |  Approved
  </code></pre>
  
  <p><strong>Sheet 2 (Data Set 2)</strong></p>
  
  <pre><code>UniqueID | Name |  Date  |  Status
  ----------------------------------------
  | 1230 | Bob   | 1/1/2016  | Denied    
  | 6985 | Mike  | 1/6/2016  | Approved    
  | 4442 | Will  | 2/27/2016 |  Approved
  </code></pre>
  
  <p>In this case, the macro would use the shared Unique ID and field name between the data sets and determine the two changes: one to a status field and one to a date field.</p>
  
  <p>Is this possible? Thank you!</p>