EXCEL VBA MASTER TIP: The Best Way To Copy / Paste Data From One Sheet To Another In Excel?
I love viewer comments! And this one deserves a video in response. If you’re interested in Excel VBA, or want to see an example of Excel automation, this session is well worth 10 minutes of your time. You can download the Excel file and work along with me to feel the power of Excel automation yourself …
The comment is about how to move data from one place to another in an Excel file. This is something hard-working professionals like you are doing in Excel all the time and it can be repetitive and demoralizing. It leaves you thinking, ‘There MUST be a better way!’
WATCH THE VIDEO HERE
The good news is Excel offers multiple ‘automation’ options for the kind of manual task. And, in this session, we cover what is in my opinion the best – Excel VBA. The viewer comment asks the best way to move data from one sheet to another with Excel VBA. Well, what would the obvious answer be? Even people with no VBA experience would suggest using copy / paste.
And, yes, Excel VBA allows us to copy / paste data around Excel at the click-of-a-button. You can even record the code yourself using Excel’s brilliant ‘macro recorder’ facility. In the session, I provide two examples of VBA code which I use all the time to copy / paste around Excel – but not to copy / paste data, as I explain in the demonstration!
The truth is there are better ways to move data around Excel than copy / paste. In this session, I share a ‘master tip’, a VBA concept that, probably more than any another, has created genuine punch-the-air moments for me over the years. And, more importantly, my customers love it too. It leaves them asking, ‘How on earth did you do that?!’
So, make sure you join me for this 10-minute Excel masterclass and get a glimpse of the awesome power of Excel automation with VBA. See you in the session!
FOLLOW-UP VIDEOS - WATCH NEXT
Excel VBA Dot Cells For Beginners (VIEWER COMMENT ON THIS VIDEO SERIES)
Set Up Your PC For Excel VBA (VBA ABSOLUTE BEGINNER TUTORIAL)
Transfer Data From One Sheet To Another With Excel VBA (BEGINNER TO PRO!)
Excel VBA For Beginners (TIGER CLASSIC – ONE MILLION VIEWS!)
Excel VBA For Beginners (6-PART FOUNDATIONAL VIDEO SERIES)
Excel VBA Position Control Mastery In 13 One-Line Macros (HIDDEN GEM!)
Excel VBA For Beginners (2024 STAND-ALONE VIDEO)
Complete Excel VBA Training Programme (FREE ON YOUTUBE)