What's up, Excel ninjas? I hope this video is helpful. I love me some macros! If you're interested in learning more about Microsoft Excel, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course
Can’t believed I just learned macros in 7min. I have been using excel and I’ve never explored macros. Its such a powerful tools especially for those who have repetitive work.
I was planning on taking a 5 hour course on Macros but this helped tremendously! I'm sure there might be some things that may be missing, but Cody nailed this in 7 minutes.
Absolutely great tutorial on macros in Excel. I hadn't done them before, and was asked about them in an interview, and was able to follow up with the employer letting them know that I could successfully do them after following along with this tutorial. If you are a Mac user, to add the Developer tab, click on "Excel" in your menu, and pick "Preferences". You will have the customized ribbons selection available to click here, and then you can enable the Developer tab. Thank you Cody Baldwin!
this video is so helpful. Anyone with zero knowledge with macro can learn doing it by themselves by just watching this 7-minute video. Thank you so so much for sharing .......looking forward to watching more of videos sir... this very informative and easy to follow.. thank you again.... Writing here from the Philippines - June 26 2022.... 9:03am
OH MY GOD. For over a decade now I've done this stuff manually, the hours of my life I've wasted, you have just given me a lot of free time haha. thank you, and so well delivered.
Huge timesaver here. Been using excel forever and I never stop learning tips and tricks in it. Thank you for your video. Good stuff. I have a spreadsheet (export) that I have to format all the time. Just created a macro to do what I need to.
Ok i will not be an expert but I was zero and with this tutorial I am able to do macro. With constant usage and learning I will be an expert...be optimistic
Zaleha Ali Yup, it’ll obviously help if you buy his full course. There’s excelisfun too if you want elaborate videos without paying. But I guess you know this already. Anyways, all the best 👌🏻
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you
Thank you. I knew about macros but have always been somewhat wary of them; they were a mystery, and on occasion spent considerable time amending spreadsheets. You have totally demystified this concept. May you live long and prosper. Fond regards from sunny Spain.
omg omg omg omg omg THANK YOU SO MUCH!! I want to cry tears of happiness! I have spent my entire day (>8 hrs) learning ways to automate/filter/delete/hide data on excel and kept running into a dead end. This video is a Godsend!!! Thank youuuuuuuuuuuuuu!!!! :'''''''''')
What an excellent, clear, straightforward introduction to macros. I was looking for something like this, for a friend who wants to learn about them, and this is perfect for the purpose. Thank you for producing it.
I just ran into this video and damn, macros look so simple when you explain them! You are a hell of a teacher, thanks for sharing the knowledge, Cody :)
I've been learning small things such as how to color a cell, change font, borders individually not knowing I could have done it as easy as this, Thank you so much! Now I'll be able to learn faster
because of your TH-cam tutorial i managed to automate our daily task kind amazing we've been struggling for long time lol, so lucky here i found this tuturial. :)
For non programmers; the recorder can be a very useful tool. I would have liked to see you mention the caveat that the recorder will perform the same action on every new report. eg 7:00 Debt to income column "C" Selection.AutoFill Destination:=Range("C2:C501") If every report has 500 lines of data; this recorded macro will work perfectly every time. However if the next report is 50 lines or 5,000 or even 50,000, the macro will only autofill between Cells "C2:C501". Understanding how to create variables and identifying dynamic ranges can make this macro capable of handling a new report of any out put size.
Sorry can you explain better. I have been using macro for a while. Assuming the initial macro was set on a 50 lines rows. If I then apply the macro on a 60 lines row, it does only that 50 lines. How do I make it extend or reduce based on the number of rows? Your help is appreciated
I understand what youre sayin since the current Data set he has only contains up to 500 lines.. then a report that exceeds it wont cover >500 lines of data.. SO do you have any solution for this? . However believe he says that when Recording Macros, it records your Mouse Click/activity.. so if he didnt Drag his mouse to select from point A to point B, BUT instead he DoubleClicked that tinyBox(?) To auto select the range, then wouldnt the next time this macro is executed, then it would also try to use AutoSelect Range by repeating the recorded DoubleClick? . *the thing im talkin about can be seen on 3:29 he didnt exactly explained how he did that but i think he DoubleClicked it.. can someone explain this? Thank you!
The Macro recorder will record the activity of exactly what was done on that report. If every time you run a report and it initially comes out the same; then yes, the recorded macro will work perfectly every time. I've been writing VBA for the last seven years as demonstrated: Selection.AutoFill Destination:=Range("C2:C501") Notice how the "AutoFill" has a property called "Destination". This will only AutoFill a "Range" between "C2:C501". The recorded macro is very static and is not capable of dynamically adjusting for the different number of rows that a new report may output. It doesn't matter if he dragged the autofill or double clicked on the lower right corner; when the curser turned into a black cross. The result of the code reflects that only the pre- mentioned range will be impacted. To fix this, you would need to set up a variable. eg "Dim lRow As Long lRow = Cells(Rows.Count, 1).End(xlUp).Row" I have made a variable called "lRow" (last Row), that is set up to identify the last used cell in the first column ("A") of the worksheet. With this variable I can modify the "Selection.AutoFill Destination:=Range("C2:C" & lRow)" Now whatever is identified as the last row will be used as the range to "AutoFill" to. The recorder is a useful tool and should be the start of any aspiring excel guru to actually spend time and learn how to write efficient/dynamic VBA. I have programmed workbooks used to reconcile complex GL accounts in minutes. Populate an AS400 program. Populate PDF documents. Learning how to write is not difficult and will simply require you to put in the time to learn and become better. Forums like MrExcel and such have people (like me) that are more than willing to assist you.
@@goombakiwi Thank you very much for the detailed explanation. I am more than willing to learn more on VBA. I'd look up your suggestion on MrExcel forums. Again, thanks for the help!
Cody - You ARE the EXCEL MASTER!!! This video has changed my life and bumped my love of Excel up not just by one notch, but by 200 notches!!!! And I bet I could learn the best way to chart that notch increase in Excel from your presentations!!! Thank you for creating such an incredible 7 minute work changing / more time in my life video!!
Adding "Screenupdating=False" as the first code line will hide the macro working and show only the result. If you use it often the macro can be assigned to a button and aded to a tool bar. Great video.
I have a Udemy Excel course that I am thoroughly happy with, but this was also a fantastic video that displayed the utility of macros. Concise, clear, and definitely helpful. Subscribed and thank you!
Wow, you are too good in teaching, just 7 min i got good idea about these and i used to think that i should write whole code to get this done, but even this as GUI settings to create, thanks Cody Baldwin.
Did not even saw the video for 30 sec but liked the video because i already liked the way u attached the sample excel file in ur description that's how u teach Yoo!
Thx Dan. I AGREE. I was just wondering why in the **** are there 3 dislikes for this video??? First of all, what is there to dislike? Secondly, I just learned Macros, PivotTables and Vlookups in about 23 minutes!!! Some folks are just so lame. Thx for ALL you do Cody, we appreciate you.
Thanks Cody Baldwin! This is the first time I am using macros. I need macros for my projects all the time, but never had the chance to use them. Thanks!
What's up, Excel ninjas? I hope this video is helpful. I love me some macros! If you're interested in learning more about Microsoft Excel, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course
sir, why does the debt to income % not sorted?
Really the easiest way to understand.. Kudos..
Awesome
Excellent video, found it very helpful. Keep posting more videos like this.
Hi could you please teach how to use macros with command buttons ..
Can’t believed I just learned macros in 7min. I have been using excel and I’ve never explored macros. Its such a powerful tools especially for those who have repetitive work.
I know! I'm using raw data on about 10 different spreadsheets daily, and I'm doing everything manually on all of them grrrrrr
@@xhyhbdka Try power query as well :)
This article is good to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi
th-cam.com/video/_87qfyAdeVk/w-d-xo.html
Please check this one too and subscribe
Im the same way. I have been doing manual manipulation of so many reports and never realized the power that this tool brings. My mind is BLOWN
I like how you zoom the camera onto the windows you’re talking about on each step!
Top notch!
th-cam.com/video/_87qfyAdeVk/w-d-xo.html
Please check this one too and subscribe
Wow. Awesome video. Instant subscription. Thank you so much. Please make more excel tutorials.
Probably the most clear explanation of what it is. Thank you for sharing this, you're a brilliant tutor who clearly understand and knows how to teach!
For more Macros click on the link - th-cam.com/video/BvDKxWnKJDc/w-d-xo.html
I am absolutely paying whatever you're charging for your full course lol. This one skill was fantasmagorically life changing.
I was planning on taking a 5 hour course on Macros but this helped tremendously! I'm sure there might be some things that may be missing, but Cody nailed this in 7 minutes.
Absolutely great tutorial on macros in Excel. I hadn't done them before, and was asked about them in an interview, and was able to follow up with the employer letting them know that I could successfully do them after following along with this tutorial. If you are a Mac user, to add the Developer tab, click on "Excel" in your menu, and pick "Preferences". You will have the customized ribbons selection available to click here, and then you can enable the Developer tab.
Thank you Cody Baldwin!
Thanks my friend :) You are making my life much easier! God bless you!
I spend at least 30 minutes each morning in reports... I can’t thank you enough for this video gentleman
You have a calming voice and explain things clearly and at a moderate pace without fillers.
this video is so helpful. Anyone with zero knowledge with macro can learn doing it by themselves by just watching this 7-minute video. Thank you so so much for sharing .......looking forward to watching more of videos sir... this very informative and easy to follow.. thank you again.... Writing here from the Philippines - June 26 2022.... 9:03am
OH MY GOD. For over a decade now I've done this stuff manually, the hours of my life I've wasted, you have just given me a lot of free time haha. thank you, and so well delivered.
For many years I was frightened by the term 'macros' whenever I came across it in excel. Now no more fear of macros. Great explanation!!
Cannot believe I have been wasting my time for the past 9 months doing the same repetitive thing every day! Thanks for the explanation!
Been using Excel for 20 years and never knew how to use Macros, until now. Thanks C-Dawg
Yesterday, my interviewer asked if I can do Macros, he tried to explain, and I promised to study that. Now, I know. Wow! Thanks for this video.
Cody, man, you're still saving lives at 2022! Thanks for this video
Huge timesaver here. Been using excel forever and I never stop learning tips and tricks in it. Thank you for your video. Good stuff. I have a spreadsheet (export) that I have to format all the time. Just created a macro to do what I need to.
Hi Cody - You have taught me from Zero to an "'Expert'' in 7mins. I bought your course. Thank you for sharing!
You’re definitely not gonna be a VBA expert with this video alone mate
Ok i will not be an expert but I was zero and with this tutorial I am able to do macro. With constant usage and learning I will be an expert...be optimistic
Zaleha Ali True, have a look at Leila Gharani’s videos, you’ll be expert in a day or two with her videos. Kudos 👌🏻
Somehow this video that Cody has meets my needs to begin. I did see lots of videos from Leila but somehow Cody is a good package for me.
Zaleha Ali Yup, it’ll obviously help if you buy his full course. There’s excelisfun too if you want elaborate videos without paying. But I guess you know this already. Anyways, all the best 👌🏻
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you
Thank you Sir, my daily task finish in 5 mins now. All 3 reports
Thank you. I knew about macros but have always been somewhat wary of them; they were a mystery, and on occasion spent considerable time amending spreadsheets. You have totally demystified this concept. May you live long and prosper. Fond regards from sunny Spain.
omg omg omg omg omg THANK YOU SO MUCH!! I want to cry tears of happiness! I have spent my entire day (>8 hrs) learning ways to automate/filter/delete/hide data on excel and kept running into a dead end. This video is a Godsend!!! Thank youuuuuuuuuuuuuu!!!! :'''''''''')
What an excellent, clear, straightforward introduction to macros. I was looking for something like this, for a friend who wants to learn about them, and this is perfect for the purpose. Thank you for producing it.
Thanks for producing high value content in short video format. Way easier to learn exactly what one was looking for and no time is wasted.
The best explanation of macros that I have found on youtube. Thanks
I just ran into this video and damn, macros look so simple when you explain them! You are a hell of a teacher, thanks for sharing the knowledge, Cody :)
I've been learning small things such as how to color a cell, change font, borders individually not knowing I could have done it as easy as this,
Thank you so much! Now I'll be able to learn faster
because of your TH-cam tutorial i managed to automate our daily task kind amazing we've been struggling for long time lol, so lucky here i found this tuturial. :)
For non programmers; the recorder can be a very useful tool. I would have liked to see you mention the caveat that the recorder will perform the same action on every new report. eg 7:00
Debt to income column "C"
Selection.AutoFill Destination:=Range("C2:C501")
If every report has 500 lines of data; this recorded macro will work perfectly every time. However if the next report is 50 lines or 5,000 or even 50,000, the macro will only autofill between Cells "C2:C501". Understanding how to create variables and identifying dynamic ranges can make this macro capable of handling a new report of any out put size.
Sorry can you explain better. I have been using macro for a while. Assuming the initial macro was set on a 50 lines rows. If I then apply the macro on a 60 lines row, it does only that 50 lines. How do I make it extend or reduce based on the number of rows? Your help is appreciated
Didn't he select the whole column it will pretty much cover all the rows.
I understand what youre sayin since the current Data set he has only contains up to 500 lines.. then a report that exceeds it wont cover >500 lines of data.. SO do you have any solution for this?
.
However believe he says that when Recording Macros, it records your Mouse Click/activity.. so if he didnt Drag his mouse to select from point A to point B, BUT instead he DoubleClicked that tinyBox(?) To auto select the range, then wouldnt the next time this macro is executed, then it would also try to use AutoSelect Range by repeating the recorded DoubleClick?
.
*the thing im talkin about can be seen on 3:29 he didnt exactly explained how he did that but i think he DoubleClicked it.. can someone explain this? Thank you!
The Macro recorder will record the activity of exactly what was done on that report. If every time you run a report and it initially comes out the same; then yes, the recorded macro will work perfectly every time. I've been writing VBA for the last seven years as demonstrated:
Selection.AutoFill Destination:=Range("C2:C501")
Notice how the "AutoFill" has a property called "Destination". This will only AutoFill a "Range" between "C2:C501". The recorded macro is very static and is not capable of dynamically adjusting for the different number of rows that a new report may output. It doesn't matter if he dragged the autofill or double clicked on the lower right corner; when the curser turned into a black cross. The result of the code reflects that only the pre- mentioned range will be impacted.
To fix this, you would need to set up a variable. eg
"Dim lRow As Long
lRow = Cells(Rows.Count, 1).End(xlUp).Row"
I have made a variable called "lRow" (last Row), that is set up to identify the last used cell in the first column ("A") of the worksheet. With this variable I can modify the "Selection.AutoFill Destination:=Range("C2:C" & lRow)"
Now whatever is identified as the last row will be used as the range to "AutoFill" to. The recorder is a useful tool and should be the start of any aspiring excel guru to actually spend time and learn how to write efficient/dynamic VBA. I have programmed workbooks used to reconcile complex GL accounts in minutes. Populate an AS400 program. Populate PDF documents. Learning how to write is not difficult and will simply require you to put in the time to learn and become better. Forums like MrExcel and such have people (like me) that are more than willing to assist you.
@@goombakiwi Thank you very much for the detailed explanation. I am more than willing to learn more on VBA. I'd look up your suggestion on MrExcel forums. Again, thanks for the help!
Great presentation! Not only were you very precise but your clear English and we'll spoken manner really helped!
After watching your video, i realise that i wasted my precious 20+ years without taking note of such essential techniques. Very nice video. thank you
I can't thank you enough for the easy explanation and the narration of the events step-by-step. Please keep them coming @Cody Baldwin
Hi Cody this is my first vid with you, i love how simple things are made, just want to comment to support, hope u keep making good vids like this!
Thank you for your very clear, concise, and consistent teaching method.
Thanks a lot. It's a magic video for me. Just within 7 minutes, I grabbed the Macros. amazing Work.
The way you make us understand the Macro is really awesome. Really Thanks to you!
Mother of … how amazing is how you show easy are macros. Thanks!
Cody - You ARE the EXCEL MASTER!!! This video has changed my life and bumped my love of Excel up not just by one notch, but by 200 notches!!!! And I bet I could learn the best way to chart that notch increase in Excel from your presentations!!! Thank you for creating such an incredible 7 minute work changing / more time in my life video!!
What a productive lecturer you are. Learnt macro in 7 minutes. Great!
Omg, I truly did learn about macros in 7 minutes. Your teaching style is the best! Thank you
Fantastic instruction. Thanks so much! The sample file you included in the description below was very helpful by allowing me to follow along!
Bro, you are the best!
I thought what I wanted to do with my Macro would take forever and it ended up being done in literally seconds!
Thanks to you!
The best, easiest and quickest explanation for an Excel tool that I have ever seen. Thanks!
You rocked it.... Hats off for your simplicity in this video...
Woowoowoow, why did i learn macros just now? Such a powerful tool! Thanks a lot for this short yet very helpful video! 😮👏👌
THIS WAS SUCH A BASIC YET EFFECTIVE VIDEO . THANK YOU
I have taken classes that were a day or two in length that I didn't learn as much as I did with this 7 min. video.
Amazing video. Much easier to understand than any other TH-cam. thank you
Wait, this is one "learn XX in 7 minutes" video that actually works!! Thank you!
He is awesome
super helpful, for people who are already well familiar with excel, that's all I needed, a quick and clear explanation. Great work!
Great video !!! THE BEST PART is providing the right amount of info !!!!
Incredible! I cannot believe how simple macros are! Thanks a bunch!
Excellent video! Brilliant. Well done. Easy to understand. Short. Precise. Clear. To the point. Useful. Much appreciated. Thank you.
You are an excellent teacher, thank you. I’ll practice and do the lesson again
I wish that I had learned this a year ago then I wouldn't need to spend a few hours of my time every day doing the same tasks every day! Thank you!
Adding "Screenupdating=False" as the first code line will hide the macro working and show only the result. If you use it often the macro can be assigned to a button and aded to a tool bar. Great video.
I really like your calm and soft voice.
Very focused and clear headed Instructions. 👌
You have got one more subscribers.. You just nailed it bro in 7 minutes. Kudos. Well keep it up. Best wishes
Thank so much - I’ve struggled with macros & now you have dissolved the myth! Many many thanks 🙏
Awesome explanation of macros, managed to put it to use right after watching the video! Thank you very much.
Got stuck on macros with an online course and this video was super helpful
This should be the blueprint to every tutorial ever
I have a Udemy Excel course that I am thoroughly happy with, but this was also a fantastic video that displayed the utility of macros. Concise, clear, and definitely helpful. Subscribed and thank you!
Which one??
yeah, which Excel course on Udemy? Is it "Microsoft Excel - Excel from Beginner to Advanced" . That one has a 4.6 star rating and 391K reviews....
Awesome, I understood the basics of macros in 7 minutes!
omg, this is the best channel for teaching excel !!!
Thanks!Finally someone explains it so simply !!! Everyone else just makes it messy and not clear
This was the very first time learning Macros. You made it so simple to understand! Thankyou so much!!
Really calm and straight forward way of explaining. Thank you so much, you just saved me a good 6 hours today (and endless hours in the future).
Wow, you are too good in teaching, just 7 min i got good idea about these and i used to think that i should write whole code to get this done, but even this as GUI settings to create, thanks Cody Baldwin.
Did not even saw the video for 30 sec but liked the video because i already liked the way u attached the sample excel file in ur description that's how u teach Yoo!
Mr.Baldwin, You are simply amazing. Thank you very much for this wonderful video. Your voice is pleasant to hear.
Hi Cody... I cannot believe that I learned the concept of Macros in seven minutes.... Awesome :) :)
Thanks!
Excellent. I really learned macros in 7 minutes. I applied in my work also
Truly, the simplest way of explaining Macros ! Very easy to understand and implement. Thanks Cody !
Excellent video. I used to fear the word "Macros" The fear is gone after watching your tutorial. Thanks a lot.
What a great explanation. Couldn't be clearer and more concise.
At the end of the demonstration my reaction was "WOW" :))). Thanks for the video!
same wtf
Thank you Cody you are super teacher. This is excellent.
Very helpful. it made me understand where all te codes came from. Thank you!
Thanks a lot for simple explanation. You made me learn all the more about it. Keep it up.
I just want to commend this guy for all his work! You're great! and all explanation is very clear! Keep it up!
Thx Dan. I AGREE. I was just wondering why in the **** are there 3 dislikes for this video??? First of all, what is there to dislike? Secondly, I just learned Macros, PivotTables and Vlookups in about 23 minutes!!! Some folks are just so lame. Thx for ALL you do Cody, we appreciate you.
This guy makes things so simple
Thanks Cody Baldwin! This is the first time I am using macros. I need macros for my projects all the time, but never had the chance to use them. Thanks!
Wowee! How easy is this. Superbly explained and such a breeze to follow along!
Really unexpected i learnt macro by 7 min video.great work
Great! I finally understand what macros are.. And in just 7 minutes! Thanks!
today i learnt this by your easy explanation of your video will use this macro feature for sure in upcoming works
Hi Cody, still relevant - 3 years later ! Thanks
For a beginner like me, you literally teach me many things such as the conditional formatting, sorting, etc.
Helpful video for beginner and everyone, THANK YOU!
Crystal clear! don't know about macros, now i have an idea. Subscriber here!
Hi Baldwin...its really helpful.You have explained the concept very clearly.Thanks a lot
Thanks for teaching Macros in such a simplified manner :)
Man this was explained in such a simple manner!! Thanks a lot!!
Very precise and spot on illustration.
Thank you.
This is way faster and cheaper than learning from a course. Thank you :)😊😉👍