Excel VBA To Move Data Between Files (BEGINNER TO PRO) Part 1/2
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.
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