title: Looping different ranges of cell in Excel using macros
body: <p>I am trying to loop a different set of ranges on an excel sheet. This is my sheet - <a href="https://i.stack.imgur.com/AZKvx.png" rel="nofollow noreferrer">Example sheet</a></p>
  
  <p><a href="https://i.stack.imgur.com/AZKvx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AZKvx.png" alt="enter image description here"></a></p>
  
  <p>When I run the macro, I want it to show up 4,6,12 and 14 in column E and F. This is my code. </p>
  
  <pre><code>Sub auto_updateTest()
  Dim rng11 As Range, cell11 As Range
  Dim rng12 As Range, cell12 As Range
  
      Set rng11 = Range("E3:F4")
      Set rng12 = Range("A3:B4")
      For Each cell12 In rng12
          For Each cell11 In rng11
      cell11.Value = cell11.Value + cell12.Value
  
      Next cell11
      Next cell12
  
  
  End Sub
  </code></pre>
  
  <p>What is the mistake here?</p>