VBA Macro to Copy Data from Another Workbook in Excel

Video Description

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