title: Copy-paste data using specific columns names
body: <p>I have a very basic knowledge and VBA but due to coding in other programming languages, I have a thought if I can copy-paste the data using specific column names in vba-excel. I use the following code till now but want to get over as I get stuck too often.</p>
  
  <pre><code>ThisWorkbook.Worksheets("Sheets2").Activate
  lastrow = Worksheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Row + 1
  Range("B2:B" &amp; lastrow).Copy Worksheets("Sheet1").Range("a65536").End(xlUp).Offset(1, 2)
  Range("A2:A" &amp; lastrow).Copy Worksheets("Sheet1").Range("a65536").End(xlUp).Offset(1, 1)
  Application.CutCopyMode = False
  </code></pre>
  
  <p>This will copy A and B column from Sheet2 to B and C column in Sheet1. Now can I do something like </p>
  
  <pre><code>Sheet2.colname.copy Sheet1.colname.offset 
  </code></pre>
  
  <p>I am just curious and any help is appreciated. Thanks.</p>