title: EXCEL VBA: Append column from one worksheet to the end of another
body: <p>I currently have the below to copy the first column from sheet 2 to the first column in sheet 1</p>
  
  <pre><code>Sheets("Sheet2").Columns(1).Copy Destination:=Sheets("Sheet1").Columns(1)
  </code></pre>
  
  <p>However, this overwrites what is there - how would I append the data to what's there already?</p>
  
  <p>Thanks</p>