Category Archives: Uncategorized

How to Copy Column Data into Another Workbook

How to copy column data into another Workbook automatically with VBA. Often we may need to copy and paste data from a worksheet column into another worksheet or into another worksheet in another closed workbook. We can automate the complete process of copying the column data using Visual Basic for Applications or VBA. Watch the training video below to transfer column data quickly and easily into another worksheet:

 

Watch this video on YouTube.

Here’s the complete VBA code to copy and paste column data from one worksheet to another worksheet in a closed workbook:

Sub copyColumn()
Dim lastrow As Long
lastrow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
ActiveSheet.Range(“C1:C” & lastrow).Copy
Workbooks.Open Filename:=”C:\Users\takyar\Desktop\test-copy.xlsx”
eColumn = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column
If eColumn >= 1 Then eColumn = eColumn + 1
ActiveSheet.Cells(1, eColumn).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, Skipblanks:=False, Transpose:=False
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

Further reference:

Copy Data Paste another Workbook Transpose Automatically using Excel VBA