title: how to copy & paste the data from one column to another between two sheets of excel workbook...without overwriting the destination column content..?
body: <p>how to copy &amp; paste the data from one column to another between two sheets of excel workbook ... without overwriting the destination column content?</p>
  
  <p>I am using below code to copy &amp; paste but every time I run it it is overwriting the existed content. I want to be pasted from next row of the column.</p>
  
  <pre><code>Sub DirectCopySample()
  
      Application.ScreenUpdating = False
      Sheets("Updating Sheet").Range("A:A").Copy Destination:=Sheets("Sheet1").Range("G:G")
      Sheets("Updating Sheet").Range("B:B").Copy Destination:=Sheets("Sheet1").Range("F:F")
      Sheets("Updating Sheet").Range("C:C").Copy Destination:=Sheets("Sheet1").Range("B:B")
      Application.ScreenUpdating = True
  
  End Sub
  </code></pre>