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

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-paste-another-workbook/

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: https://youtu.be/sfspd_QdbMg

Video series on 3 ways to Find the Last Used Row/Column with VBA: https://youtu.be/vw1zIAyfzro

Video series on The Personal Macro Workbook:
https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

VBA Context Assumptions (how to reference workbooks and sheets): https://youtu.be/VohlY8WqLCg

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-webinar
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