The Ultimate Guide to Copying Data using Excel VBA

In this video I'm going to cover everything you need to know about copying data using VBA. We're going to look at:
* What to avoid
* How to ensure your code runs fast
* How to get the correct worksheet every time
* An indepth look at the 4 methods
* The pros and cons of each method

#excelvba #excelvbacopy #ExcelVBAArray #ExcelVBAAdvancedFilter #ExcelVBAADO


SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY

DOWNLOAD THE SOURCE CODE FOR THIS VIDEO: https://bit.ly/3cflkjT


(Blog Post)Excel VBA Copy – The Complete Guide to Copying Data: https://excelmacromastery.com/excelv...
(Blog Post)VBA Advanced Filter: A Complete Guide: https://excelmacromastery.com/vbaadv...
(Blog Post)Excel VBA Array – The Complete Guide: https://excelmacromastery.com/excelv...

YouTube Video: How to use ADO and VBA to Read from Worksheets:    • How to use ADO and VBA to Read from W...  
YouTube PlayList: Excel VBA Copying and Filtering Data:    • Excel VBA Copying and Filtering Data  
YouTube PlayList: Excel VBA Arrays:    • Excel VBA Copying and Filtering Data  

Related Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives 60+ Hours of VBA training(https://excelmacromastery.com/excelv...)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vbaart...)

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

Table of Contents:

00:00 Introduction
00:26 Don't do this
01:06 Speeding up your code
02:16 Get the correct worksheet every time
02:31 How to get the correct worksheet
05:45 How to get the correct data range
07:11 Method 1: For Loop & Range
12:38 Method 2: For Loop Arrays
16:26 Method 3: Advanced Filter
26:40 Method 4: ADO