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.

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 The Personal Macro Workbook:

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

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

Рекомендации по теме

Комментарии

Lots of additional links and resources in the description above. Please leave a comment below with any questions or suggestions. Thanks!

ExcelCampus

I think you just saved my internship!!

MsQuikly

WOW! This is exactly what I needed. It seems like you made this tutorial video for me.
I just modified it to go through 12 Sheets (January through December) using a For/Next Loop to copy non-blank range then paste values in the next blank row after destination file/sheet is cleared once.
Thank you, thank you, thank you.

DerickPitcher

Just found this today and it helped me a lot to try and automate manual copy and pastes of my teammates. Will be trying to put some of these in a button.

darrelljustinlopez

Thank you very much for this high quality video. You are very detailed and clear in your explanations which helps tremendously. I've been manually copying and pasting data from 12 spreadsheets to a master spreadsheet monthly and am looking forward to automating it.

jrm

Thank you Jon! You've just helped me to become a successful man!

norbertfris

1a) 3:13 - Open/ Close source Workbook
2) 10:02 - Clear Existing Data in destination before Pasting
3a) 7:15 - Copy/Paste below Last Cell in destination Workbook.
3b) 10:36 - Alternate destination Workbook reference.
3c) 11:36 - Copy/Paste below Last Cell in destination Workbook if worksheet name is unknown.

firststep

This tutorial shows exactly what I'm trying to achieve with an Excel project I've started recently...Brilliant ! ;-)

mikevanwieringen

I am so happy with the content of this tutorial, thank you very much Excel Campus !

nathanaelmouckagni

I'm working on a project and cam across this video, what you've done will help so many! Thanks so much Jon awesome video Great job Sir!

joshuabrockman

Great job, saved me a lot of time! God bless you

MaStErful

This helped me so much at work. Thank you!

ShaneNickers

Very useful & I've incorporated this into my latest video where I've created an awesome tool for the average side-hustler. Thank you!!!

FlowerCityCards

So comprehensive, so successful
Learn VBA with Jon
Thank you bro, thanks a

alperak

Thank you. You make my life easy to live.

tuntunsaw

thank you very much as a newbie at VBA it captured my mind and I got passionate about thank you for your videos

MohamedRAMDANI-rijp

hmm... DUde, what to say this was actually some instructive information! Thank you for explaining the ❤👍

NeoclassicYT

Thank you for your useful tutorials! I quickly earned "Wizard" status at my new job by writing a macro that copies in data from date stamped system generated files using Application.FileDialog to set workbook variable and your lastrow/range.copy videos.

a.j.wilkes

it's fantastic dude
thanks you, thanks a lot
greeting from Istanbul

alperak

Thank you so much. This is very helpful

shoebkhan

VBA Macro to Copy Data from Another Workbook in Excel

VBA Macro to Copy Data from Another Workbook in Excel

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

VBA Macro to Copy Data to Another Workbook

Excel VBA - Copy Paste

VBA to BROWSE & COPY Data from SELECTED File in Excel

Excel VBA to Copy/Move Data Within Sheet, to Another Sheet or Another Workbook

Excel VBA To Copy Data From One Sheet To Another (BEGINNER TO PRO!)

Excel VBA: Copy Data Between ANY Two Sheets

Excel Interview question Day 2/30 #excel #exceltips #excelformula #exceltricks #trend #trending

VBA Macro Code to Copy Filtered Data to Another Worksheet

Easiest Ways to Copy and Paste Cells with Excel VBA (copy, pastespecial, resize & offset)

Copy Filtered Data To New Sheets Excel VBA Macro

The Ultimate Guide to Copying Data using Excel VBA

How to Write VBA Macros to Copy and Paste Cells in Excel - Part 1 of 3

VBA Macro to Copy Data Dynamically From One Sheet to Another

Move or Copy Rows & Columns Using Excel VBA, Including Move to Another Sheet and Move to End of ...

VBA Advanced Filter - The FASTEST way to Copy and Filter Data

VBA code to copy table data from word to Excel

VBA to Copy and Paste Filtered data

Copy Paste Filtered Data using simple VBA code (2021)

VBA to Copy and Paste Rows if Condition is Met - Excel VBA Example by ExcelDestination

Excel VBA Macro: Autofilter, Copy, Paste to New Sheet and Save to Specified Location (Dynamic Range)

Excel VBA Copy Paste Range to another Sheet - Macro for Copy Paste

Excel VBA - Copy Paste Data Range From Another Worksheet or Workbook - Part 5