title: how to merge to two table into one complete table and delete duplicates with together criteria
body: <p>what i need is merge two table into one and delete the duplicates with criteria.
  Table 1 + Table 2 = Table 3</p>
  <p>Table1
  <a href="https://i.stack.imgur.com/ZQPuO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZQPuO.jpg" alt="enter image description here" /></a></p>
  <p>Table2
  <a href="https://i.stack.imgur.com/5bhrp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5bhrp.jpg" alt="enter image description here" /></a></p>
  <p>Table3
  <a href="https://i.stack.imgur.com/aj7b4.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aj7b4.jpg" alt="enter image description here" /></a></p>
  <p>What i need is like table 3.</p>
  <p>This criteria normally will in SQL,but i want to do it Excel VBA
  Thanks in Advance</p>