title: How to merge two different tables and then create a new one with vba?
body: <p>I am trying to merge two different tables on two different sheets and paste the results on the other table in another sheet?</p>
  
  <p>For instance, SUM:</p>
  
  <pre><code>          sheet 1 ("A1") = 1
            sheet 2 ("A1") = 2
  
   PASTE to: sheet 3 ("A1") = 3
  </code></pre>
  
  <p>My tables are dynamic and big ("A1:D27"), I couldn't find a way to loop through each cell in order and paste to the next one?</p>
  
  <p>I have tried to loop each cell but not working, I tried copy paste and add but not working with dynamic range.</p>