title: Compare rows in two different sheets
body: <p>I have two worksheets to compare. Sometimes a whole row of data may be added, deleted or changed. I need to compare this to the other worksheet.</p>
  
  <p>For example, if one worksheet looks like:</p>
  
  <pre><code>(Sheet 1)
  Max J 89231 
  Sam L 82313
  Penny H 23456
  Mary K 91423
  </code></pre>
  
  <p>And the next Sheet looks like:</p>
  
  <pre><code>(Sheet 2)
  Sam L 82313    (Max J Removed)
  John S 71234   (Penny H changed to John S)
  Mary K 91423
  Thomas N 18123 (Thomas N added)
  </code></pre>
  
  <p>How do I display the differences in rows for the two sheets, in e.g. sheet3 using a macro?</p>
  
  <pre><code>(Sheet 3)
  Max J 89231 
  John S 71234  
  Thomas N 18123
  </code></pre>