Post Time: 2026-03-13

Country: United States, Australia, United Kingdom. City: Aurora, Lakeland, Lowell, Plano, SunnyvaleSign up for our Excel webinar, times added weekly: Learn how to use VBA macros in Excel to copy data from one workbook to another, and how to copy Recommended Web-site 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 click through the next internet site 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 visit site 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: 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