title: Excel Macro - Compare 2 rows and copy duplicate
body: <p>Is it possible to have a macro run to find duplicate information from page 1 and 2 then copy it to the third?</p>
  
  <p>For example.. Search through Sheet 1 - A1 to bottom of the data
  Compare this with Sheet 2 A1 to bottom of the data</p>
  
  <p>If a duplicate is found then copy that row to Sheet 3?</p>
  
  <p>Then loop this?</p>
  
  <p>I've had a look around, But nothing works if the data is in random order.</p>