title: Copy data from one column, paste in first empty column
body: <p>I have data in COLUMN H2. . I want to copy them somewhere else on the same spreadsheet.
  But where I copy it will change one COLUMN at a time, as each column below gets filled, by the macro.</p>
  
  <p>My existing macro successfully searches for, and pastes this column of data into an empty column below, such as B31. When I have 10 new pieces of data, the next time I run the macro, I want it to paste it into C31, in Column C (being the next empty row) The next time, D31.......etc.. My macro repeatedly grabs the data in H2:H11 and pastes it into B31, but overwrites that column each time I run the macro again. It is not "seeing" column B already having data placed there by running the macro before.... What is wrong with the code?</p>
  
  <pre><code>Range("H2:H11").Select Selection.Copy
  Range("A31").Select
  Range("A31:M31").End(xlToLeft).Offset(0, 1).Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  ActiveCell.Rows("1:10").EntireRow.Select
  Application.CutCopyMode = False
  </code></pre>