VBA Macro to Copy Data from Another Workbook in Excel

Learn how to use VBA macros in Excel to copy data from one workbook to another, and how to copy data below an existing range.
Download the Excel file to follow along:

In this video I explain different techniques in VBA to copy a range of cells from one workbook to another. You will learn the regular Range.Copy method, and I also explain how to copy paste values only.

I also explain how to do a dynamic copy & paste, where the copy range changes every week. You might be exporting data and not sure how many rows you need to copy. I explain how to use VBA to find the last used row and reference the dynamic range.

I also explain how to copy data below the last used row in the destination sheet. This allows for a fully automated copy and paste to add or append data to an existing data table or range.

Additional resources mentioned in the video:

Video series on 3 ways to Copy/Paste with VBA:

Video series on 3 ways to Find the Last Used Row/Column with VBA:

Video series on The Personal Macro Workbook:


VBA Context Assumptions (how to reference workbooks and sheets):

🚀If you're new to VBA then checkout my free upcoming webinar on The 7 Steps to Getting Started with Macros & VBA.

👉Register here:

excel,excel campus,excel vba copy range to another workbook,excel vba copy from one workbook and paste into another,how to move data from one sheet to another in vba,copy data from one sheet to another in excel macro,excel macro copy from one workbook to another,vba copy data from one workbook to another,VBA Macro to Copy Data from Another Workbook in Excel,excel vba,microsoft excel (software),excel vba training,copy data from one sheet to another,