title: Needing to simply check two columns against one another and out put what is different
body: <p>You would think that this question has been answered before but I can not locate 1 person who has had to do this this way. I have Two sheets being compared for dates only on column A starting at A3. If the second sheet's Column A is missing a Date then I want it to just output that date starting at I3 of the second sheet. I feel like it is super simple but the code I have pieced together always messes up. <a href="https://i.stack.imgur.com/37SWU.png" rel="nofollow noreferrer">SHEET 1</a> </p>
  
  <p><a href="https://i.stack.imgur.com/aT4bN.png" rel="nofollow noreferrer">SHEET 2</a>     </p>
  
  <p>If anyone wants the Code Ill gladly upload it, but I don't think it is correct at ALL.</p>
  
  <pre><code>Sub jim()
  Dim CompareRange As Variant, To_Be_Compared As Variant, x As Variant, y As Variant
  
  Range("A").Select
  Selection.End(xlDown).Select
  Set To_Be_Compared = Range("ALPHA!A3:" &amp; Selection.Address)
  Range("B").Select
  Selection.End(xlDown).Select
  Set CompareRange = Range("OUTPUT!A3:" &amp; Selection.Address)
  
  
  
  i = 1
  To_Be_Compared.Select
  
  For Each x In Selection
      For Each y In CompareRange
          If x = y Then
            Range("I3" &amp; i).Value = x
            i = i + 1
          End If
      Next y
  Next x
  End Sub
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/37SWU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/37SWU.png" alt="OP&#39;s sample"></a></p>