Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

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: https://www.excelcampus.com/vba/copy-...

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:    • How to Write VBA Macros to Copy and P...  

Video series on 3 ways to Find the Last Used Row/Column with VBA:    • Find the Last Row, Column, or Cell in...  

Video series on The Personal Macro Workbook:
   • The Personal Macro Workbook in Excel ...  

VBA Context Assumptions (how to reference workbooks and sheets):    • 2 Critical Excel VBA Assumptions You ...  

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

👉Register here: https://www.excelcampus.com/yt-vba-we...
00:00 Introduction
00:11 How to Use VBA Macros to Copy Data to Another Workbook
00:50 Copy Data from One Workbook to Another Using Excel Macros
01:09 Important Points to Remember
08:26 Step though Code