New Video Added To YouTube!

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...

Introduction To The Mass Data Getter(er) With VBA

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:

11 views0 comments

Recent Posts

See All

You can access all of my individual courses via a low cost monthly subscription, with the first 2 months completely free! 

If you want to access ALL of my courses (including future releases), and 27,000 other premium courses, just choose the subscribe button below any of the courses.


Subscription: By following a subscribe link, you will get two months free full access to all of my courses, as well as 27,000 other premium courses, on the SkillShare platform. After your two month free trial, the charges are (at time of print) $15.00 a month for a monthly subscription, or $8.25 a month if you pay for a year up-front ($99). That's great value, and if you decide it's not for you, just cancel your subscription within the first 60 days, and you won't pay a penny. You can also cancel your subscription at any point after the 60 day free period, but you will be charged for that month. You can't say fairer than that!

Purchase: Super Memory Essentials, Leadership and Management Essentials, and The Complete Excel Series (including Levels 1, 2 and 3) are available for purchase via the Udemy platform...just click " Buy Now..." or "Purchase Lifetime Access..."button and your special discount will be applied automatically. This option give you lifetime access, and is backed by the Udemy full 100% money back guarantee. So, if you're not entirely happy, you can get all of your money back, no questions asked.

That sounds good, right? I thought so. So, choose your path to learning, and I'll see you in the course(s).

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube

© 2023 by Personal Life Coach. Proudly created with