VBA Marcro Code to copy data from one workbook to another
In this video, you will learn how you can write VBA Code to copy data from one workbook to another workbook.
Here is the macro code used in this video:
Sub CopyDataToAnotherWorkbook()
Workbooks("VBA Training.xlsm").Worksheets("Sheet1").Range("B5:D15").Copy
Workbooks("Book1.xlsx").Worksheets("Sheet1").Range("B5").PasteSpecial xlPasteValues
End Sub