I am on a roll this year! I have just published another new lecture on YouTube :)
There are a whole host of free videos you can check out on my YouTube channel, just check out the links at the bottom of this post...why not take a look.
I have uploaded a bunch of new content, subscribe on YouTube, and you will be notified as each becomes live...
This video is taken from my Excel tutorial course, Excel Essentials Level 3, which will teach you everything you will ever need to know about coding in VBA.
This is really useful bit of code I wrote for a student. What he has is a consolidated report he needs to keep updated, but the problem is that the source data is spread across hundreds of different workbooks each with dozens of different sheets...and we need to get the right data from the right sheet, and add it to the correct part of the consolidated report. An absolute nightmare with copy and paste, but a breeze with code!
The full code is available in the course.
This course is for suitable Excel 2007, Excel 2010, Excel 2013 and Excel 2016
Videos in the Level 1 series:
Videos in the Level 2 series:
Videos in the Level 3 series: