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
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!
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!!!! :'''''''''')
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.
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you
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 👌🏻
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 :)
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.
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.
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.
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
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.
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!
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!
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.
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.
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!!
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. :)
Great explanation! This has saved me a lot of time. Thanks very much. Another tip, when you want to do a Find & Replace, you can use CTR+H, instead of using CTR+F and then clicking on Replace.
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!
Thank you! Getting ready for an interview. Your tutorial helped me to refresh macros knowledge. Would you also add comments during videos that mention shortcuts you use to fill formulas for example? I did find it but it would save me some time if you said it out loud. Thanks again! Very useful tutorial
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 ..
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
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 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.
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.
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!
Thank you Sir, my daily task finish in 5 mins now. All 3 reports
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!!!! :'''''''''')
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!!
I am absolutely paying whatever you're charging for your full course lol. This one skill was fantasmagorically life changing.
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.
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. 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!
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 👌🏻
Cannot believe I have been wasting my time for the past 9 months doing the same repetitive thing every day! Thanks for the explanation!
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 :)
Been using Excel for 20 years and never knew how to use Macros, until now. Thanks C-Dawg
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.
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
Cody, man, you're still saving lives at 2022! Thanks for this video
Thanks my friend :) You are making my life much easier! God bless you!
Incredible! I cannot believe how simple macros are! Thanks a bunch!
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.
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.
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.
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
Great presentation! Not only were you very precise but your clear English and we'll spoken manner really helped!
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 can't thank you enough for the easy explanation and the narration of the events step-by-step. Please keep them coming @Cody Baldwin
The best, easiest and quickest explanation for an Excel tool that I have ever seen. Thanks!
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
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!
Thanks a lot. It's a magic video for me. Just within 7 minutes, I grabbed the Macros. amazing Work.
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!
Woowoowoow, why did i learn macros just now? Such a powerful tool! Thanks a lot for this short yet very helpful video! 😮👏👌
You rocked it.... Hats off for your simplicity in this video...
Thank you for your very clear, concise, and consistent teaching method.
Wait, this is one "learn XX in 7 minutes" video that actually works!! Thank you!
He is awesome
Hi Cody, still relevant - 3 years later ! Thanks
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....
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.
Omg, I truly did learn about macros in 7 minutes. Your teaching style is the best! Thank you
Wow. Awesome video. Instant subscription. Thank you so much. Please make more excel tutorials.
Mother of … how amazing is how you show easy are macros. Thanks!
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.
Excellent video! Brilliant. Well done. Easy to understand. Short. Precise. Clear. To the point. Useful. Much appreciated. Thank you.
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).
The best explanation of macros that I have found on youtube. Thanks
Thank so much - I’ve struggled with macros & now you have dissolved the myth! Many many thanks 🙏
Thank you Cody you are super teacher. This is excellent.
The way you make us understand the Macro is really awesome. Really Thanks to you!
Very focused and clear headed Instructions. 👌
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!
You are an excellent teacher, thank you. I’ll practice and do the lesson again
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!!
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!
What a productive lecturer you are. Learnt macro in 7 minutes. Great!
THIS WAS SUCH A BASIC YET EFFECTIVE VIDEO . THANK YOU
Amazing video. Much easier to understand than any other TH-cam. thank you
Awesome explanation of macros, managed to put it to use right after watching the video! Thank you very much.
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. :)
Crystal clear! don't know about macros, now i have an idea. Subscriber here!
Really unexpected i learnt macro by 7 min video.great work
This guy makes things so simple
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.
I really like your calm and soft voice.
This was the very first time learning Macros. You made it so simple to understand! Thankyou so much!!
super helpful, for people who are already well familiar with excel, that's all I needed, a quick and clear explanation. Great work!
Excellent. I really learned macros in 7 minutes. I applied in my work also
Thanks!Finally someone explains it so simply !!! Everyone else just makes it messy and not clear
You have got one more subscribers.. You just nailed it bro in 7 minutes. Kudos. Well keep it up. Best wishes
Truly, the simplest way of explaining Macros ! Very easy to understand and implement. Thanks Cody !
Great! I finally understand what macros are.. And in just 7 minutes! Thanks!
Excellent video. I used to fear the word "Macros" The fear is gone after watching your tutorial. Thanks a lot.
Got stuck on macros with an online course and this video was super helpful
Helpful video for beginner and everyone, THANK YOU!
Thank you Cody! I really appreciated this act of kindness :)
Excellent..clear and simple.
Very helpful. it made me understand where all te codes came from. Thank you!
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
Thanks a lot for simple explanation. You made me learn all the more about it. Keep it up.
Man this was explained in such a simple manner!! Thanks a lot!!
today i learnt this by your easy explanation of your video will use this macro feature for sure in upcoming works
For a beginner like me, you literally teach me many things such as the conditional formatting, sorting, etc.
This is so straightforward and easy to understand. Thank you so much
Mine didn't do the sort properly on week 2 but otherwise it seemed to work.
omg, this is the best channel for teaching excel !!!
Great video !!! THE BEST PART is providing the right amount of info !!!!
I'll try this tomorrow and try to get rid of my repetitive work!
Great explanation! This has saved me a lot of time. Thanks very much.
Another tip, when you want to do a Find & Replace, you can use CTR+H, instead of using CTR+F and then clicking on Replace.
If I had known how to use this in my past job that would have saved me hours. Thanks for this super simple tutorial.
You're a great teacher! Thanks for this video.
Wow. This is brilliant!!! Thank you very much Cody.
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.
I was much easier than I thought it would be and explains what it actually does!
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!
Thank you! Getting ready for an interview. Your tutorial helped me to refresh macros knowledge. Would you also add comments during videos that mention shortcuts you use to fill formulas for example? I did find it but it would save me some time if you said it out loud. Thanks again! Very useful tutorial