title: Copy from page 2 to last cell
body: <p>Ok so this is hard to explain, Will be better if I show you.</p>
  
  <p>I'm pulling data from page 2 - Cells A &amp; B</p>
  
  <p>Each time the amount of rows will be different so I'm trying to make a Macro copy the cells from a pre-made box on page one to the end of the row on page 2.</p>
  
  <p>Say on page 2 the rows stop at 25, I only want it to copy 25x on page 1</p>
  
  <p>Here's how it looks, and if I highlight the box's then put the mouse at the bottom right I can drag it down and it copies it for me.. This is what I'm trying to make the macro do.</p>
  
  <p>However, I don't know what to use for my Macro?!</p>
  
  <p><img src="https://i.stack.imgur.com/FjZWV.png" alt="enter image description here"></p>
  
  <pre><code>Sub Test()'
  
      Range("G2:J3").Select
      Range("J3").Activate
      Selection.AutoFill Destination:=Range("G2:J5"), Type:=xlFillDefault
      Range("G2:J5").Select
  End Sub
  </code></pre>