title: Input Form, Excel, VBA to copy inputs and paste in another worksheet
body: <p>I am trying to reduce using <code>.select</code> and <code>.paste</code> when trying to perform a copy and paste. I know using loops are way easier. I'm trying to copy a range of cells from my worksheet "Entry" and paste it into a worksheet called "input". The problem I'm running into is that I want to paste the data into consecutive cells. </p>
  
  <p>Here's what I have so far: </p>
  
  <pre><code>Dim i as Byte, y as Byte, x as integer 
  
  For i = 3 to 3 
      For y = 3 to 17
        x = x +1 
  
        Sheets("input").Cells(29,x).value = Sheets("Entry").Cells(y,i).value
  
       Next y 
  Next i
  </code></pre>
  
  <p>The cells that are copied have an empty cell in between like the this: </p>
  
  <p><img src="https://i.stack.imgur.com/VIEu3.png" alt="Entry Cells that are copied"></p>
  
  <p>When I paste them into the "input" tab at the range that I want it pastes it like this: </p>
  
  <p><img src="https://i.stack.imgur.com/TWBly.png" alt="Input Paste"></p>
  
  <p>I'm trying to get it so that when pasted, it pastes consecutively into the "input" worksheet like this: </p>
  
  <p><img src="https://i.stack.imgur.com/7bXBv.png" alt="Consecutive Cells"></p>