top of page

New video added to my YouTube Channel!

It's been a while, but I'm back, and I have just added another great new video 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.


A great question from Katerina...


She has a huge data table, with various data sets segmented off into groups (like all sales from shop A could be lines 2-99, shop B could be 100-105, shop C 106-457 and so on.


What we want to do here, is reuse the same array to read Shop A's data, then go away and perform some other clever stuff on THAT data block using code you have already written, then empty the array, and reuse it for shop B, than then C...and all the way until we have been through every variation.


The advantage in this approach is that you only need one array, and you can reuse it, rather than having a seperate array for each "Shop" you may have (which could be a different number each time). Hope it may help you too! Happy coding, and enjoy!


Be sure to check out the other videos on the channel...there are quite a few!


Videos in the Level 1 series:


https://youtu.be/uNFJNJk_kyo

https://youtu.be/g4ExVFkrj7I

https://youtu.be/Sd7w4YrVKmQ

https://youtu.be/XPfZA-KrOrM

https://youtu.be/CGNP1jKAhGA

https://youtu.be/6At4-dfrWSM

https://youtu.be/6QSm0iNA-gc

https://youtu.be/NWRFK2SOTtA

https://youtu.be/CYCFs4dQnm8


Videos in the Level 2 series:


https://youtu.be/4B4VFgHfcCI

https://youtu.be/B6G5Vu97GIw

https://youtu.be/-YL6h4ZaPec

https://youtu.be/fSwl1kEwMdg

https://youtu.be/ij0_SkPhB_M

https://youtu.be/MHbOHpBxTa0

https://youtu.be/bDPJP2t28_A

https://youtu.be/Y5E2FZ8KHgM

https://youtu.be/LSGUDpBPWb8

https://youtu.be/DhwXh6IplPk

https://youtu.be/B5k1lbIC5lQ

https://youtu.be/DZq9TxIaecI

https://youtu.be/41Ke-oEEGUk

https://youtu.be/xn0VSwQ0Vpc

https://youtu.be/haZpJhLJbdA


Videos in the Level 3 series:


https://youtu.be/IzbCv0yWAUI

https://youtu.be/zw9ydY-GVXo

https://youtu.be/DZc0ekkOFTg

https://youtu.be/L0V1WkC7bzQ

https://youtu.be/2vUSnj9ULYk

https://youtu.be/itTaurKxZp0

https://youtu.be/w4d_SUMqNxM

https://youtu.be/9OOJu4pxOGc

https://youtu.be/rkf7Wc-CQIY

https://youtu.be/2QXcBWYlL_I

https://youtu.be/rHqnzyw-asw

https://youtu.be/QeUgI_d-ljU

https://youtu.be/DjlzkGmDOok

https://youtu.be/JM7NFLDGaJE

https://youtu.be/kNkL21Iw9bk

https://youtu.be/Y6s3MEV1CIk

https://youtu.be/tGBsYjwbldQ

https://youtu.be/398-GMY0z78

https://youtu.be/k-r2N-Bz1Os

https://youtu.be/EELAr2myuog

https://youtu.be/qAbiXRHFkoI

https://youtu.be/BJiI0CrqG1E

https://youtu.be/IIf4vZgHvGE

https://youtu.be/9Vl8NxWmy00

https://youtu.be/ZFqqX4Q7rA0

https://youtu.be/yhTrqnKh9uU

https://youtu.be/1m1rd_UWPT0



18 views0 comments

Recent Posts

See All
bottom of page