title: Copy Paste two lines below Macro
body: <p>I am a VBA beginner and therefor, the following query might be very easy for you, but I can’t make it</p>
  
  <p>What I am trying to is the following: </p>
  
  <p>Build a macro with </p>
  
  <ol>
  <li>Input with Date and Credit Rating on one sheet (existing) and </li>
  <li>copy and paste it into a predefined table and</li>
  <li>everytime you enter new data into the input field and click the macro button, the macro should copy and paste it into the table again, BUT two lines below the last cell/row used. </li>
  <li>have a chart reading the data of the range, where the data are pasted to and automatically adjusts its range to the newly pasted values. </li>
  </ol>
  
  <p>I hope, that I’ve explained my problem good enough, so that you can help.</p>
  
  <pre><code>Dim x As Integer 
  Worksheets("Input").Range("D6:D7").Copy 
  x = 2 
  Do 
    x = x + 2 
    Worksheets("Chart").Range("B" &amp; x).PasteSpecial Paste:=xlPasteValues,Transpose:=True, xlPasteValues 
  Loop Until x = 56 
  Application.CutCopyMode = False 
  End Sub
  </code></pre>
  
  <p>Thanks!</p>