New video added to my YouTube channel!
- Alan Jarvis
- Aug 4, 2020
- 2 min read
It's been a while, but I've finally got around to adding another free video to my to my YouTube channel...
If you like this video, please hit the subscribe button!
This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming), which will teach you everything you will ever need to know about coding in VBA.
All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.
So, this is another SQA (Student Questions Answered) lecture, this one from Neil...and it's a great one...
Neil works in the Energy industry. What Neil has is a HUGE data set with over 4000 lines across dozens of columns...with all the data laid out this way, it's a bit of a mess!
What we want to do, is analyse this data, and create a new workbook with multiple tabs, one for each unique MPAN (a 13 digit code), and return each of the 48 entries for all 365 days for that particular MPAN to the appropriate sheet laid out in a nic easy to read table!As always, we walk through the code line by line so we can see exactly how it is built, and what it is doing at each step...all simple steps, which, when combined can save hours of work!
So, all the code is here, and a complete walkthrough of how it works.
Enjoy!
Be sure to check out the other videos on the channel...there are quite a few!
Videos in the Level 1 series:
Videos in the Level 2 series:
Videos in the Level 3 series:
Comments