title: Increment Row value in excel on each button click
body: <p>in excel macro I need to increment row each time I click the button. Sort of Next value function that should be read from the datasheet. Also this value needs to be returned to a cell in a different sheet. This is the code I have, how do I increment the value per click. I tried Offset() but I want the button to remember my previous position. Something in For loop maybe</p>
  
  <pre><code>Sub Button6_Click()
  
  Cells(4, 6) = Sheets("Sheet4").Range("B:B").Value
  
  End Sub
  </code></pre>