Excel VBA: Copy Data Between Worksheets Using For Loops
In this lesson from the Excel VBA For Professionals series, you'll learn how to access and copy values between multiple worksheets in Excel using VBA. This tutorial is perfect for professionals in finance, science, and data-heavy fields who want to automate routine Excel tasks.
✅ What you’ll learn:
How to reference multiple worksheets with Worksheets()
How to use For loops to iterate over rows and columns
How to copy data from one sheet to another using VBA
How to fix logic errors and troubleshoot dynamic formulas like =RAND()
📌 Real-world example: Copying data from a "Sales" sheet to a "Production" sheet using just one button.
🔧 Tools Used:
VBA Macros
For Loops
MessageBox
Excel Developer Tab
🧠 No ads. No fluff. Just clean, efficient Excel VBA code.
🔗 Subscribe and follow for more Excel automation:
00:00 – Intro: Accessing worksheets in VBA
00:22 – Recap: Last lesson on buttons and VBA
00:48 – Creating additional worksheets (Production, Sales)
01:23 – How to access specific worksheets using index
01:51 – Referencing a cell in a specific worksheet
02:12 – Displaying a worksheet value using MsgBox
02:54 – Copying cell values between two worksheets
03:52 – Understanding worksheet indexing
04:18 – Goal: Copy a range of cells using a macro
04:39 – Setting up row and column variables (i, c)
05:07 – Nested For Loop setup: rows and columns
06:00 – Copy cell values from one worksheet to another using For loops
07:26 – Testing the loop-based data copy macro
08:00 – Debugging a logic error caused by random formula (`=RAND()`)
08:52 – Final explanation of the logic bug and fixing it
09:15 – Outro: Subscribe for ad-free Excel VBA tutorials