How much time do you / your colleagues / your team spend moving data from one Excel file to another?  If you’re reading this, probably a lot!  It’s time-consuming, prone to error and can leave you feeling, ‘there must be a better way!’

I personally found moving data from one Excel file to another instantly with Excel VBA was something of a turning point in my career.  The ability to do a huge amount of manually work at the click-of-a-button with VBA really impressed (prospective) customers, unlocking bigger, higher value projects.

DOWNLOAD FILE LINKS

WATCH THE VIDEO Here

In this two-video series, I share the secrets of copying data from one Excel file to another – I hope these have a similar impact on your career!  We start with the basics, but don’t miss the second video with the actual approach I use – it’s mind-blowingly good …

The first video starts at beginner VBA level.  We first get familiar with the foundational concept of a=b - where a is the destination and b the origin.  This syntax shapes all of the VBA structures in the series from beginner to professional – so always bear it in mind, and come back to it if things get complicated!  A=b, destination equals origin.

The first step is to test out the a=b concept within the worksheet, by transferring data from one cell to another.  I personally found even this impressive when it was first shown to me, many years ago.  But we’re just getting started!  Once you ‘copy’ data from on cell to another, it’s a small step to transfer data across worksheets, then across files, as I show you in the first video of the series.

I hope you are able to apply these techniques to your work.  The applications and possibilities for saving time and resources are endless.  I would love to hear how you apply the concepts in the YouTube comments – I will get back to you there, and will happily answer your questions, too.

WATCH NEXT

Excel VBA For Beginners (Get Started With 1 Video!)

Excel VBA For Beginners (6 Video Series)

17 Things You Must Know About The Excel VBA Editor

Create Powerpoint Presentations Instantly With VBA

The 5 Levels Of Excel Automation

Copy Data With Excel VBA (2021 Version Of This Video)