3 New videos added to my YouTube channel!

It's been an interesting few weeks, and we are certainly living in a different world today, but I didn't want all that get in the way of adding more free content for you.


Though I haven't posted here, I have actually uploaded 3 (yes THREE) new videos for free on my YouTube channel.


Video 1: Saving An Individual Sheet To A Specific Folder With VBA

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.


This is another student questions answered lecture...here's the scenario: We have a single workbook, with scores of different sheets, each one belonging to a specific territory manager (though it could be anything). The challenge is, if we make a change to anything in any of the individual sheets, a copy of THAT SPECIFIC sheet (and ONLY that sheet) is automatically saved to the SPECIFIC FOLDER that belongs to THAT SPECIFIC territory manager! Really useful if you pull data from a system (sales data, for example), and you want to get specific portions of that data to specific people who have access to their own specific folders on the system


Okay, you will find the full VBA code here, with a complete walkthrough of what each line does.


Video 2: Saving Multiple Sheets To A Single Workbook In A Specific Folder With VBA



This is another SQA lecture . This one covers copying multiple sheets from a master workbook to a specific file, and then save THAT newly created file to a specific folder in a specific directory...sound like there's a lot going on, but it's actually a breeze, and once you're set up, you're pretty much good to go!


There is a catch here, if you just record a macro to select multiple sheets, what you actually get is an ARRAY of those sheets...which makes it a bit of a pain as you would have to modify your code to change the names within the array every time you wanted to pick different sheet! A royal pain...I have a different way of doing it, which you will see here.


Video 3: Animated Charts...With A Little Something Extra! With VBA


Another student question answered, this one from Alessandro...and this one is all about making dynamic charts, and specifically making ANIMATED CHARTS.


Very simple, a FOR...NEXT loop to increase the value of the key cell by 1 for each pass, with a little pause thrown in so we can actually see it :)


And as an added bonus, just for fun more than anything else, we'll make Excel SPEAK to us while it's doing it!


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/NKaund7qNbU





25 views0 comments

Recent Posts

See All