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.
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!!!! :'''''''''')
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.
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you
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.
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'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
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 :)
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!!
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.
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!
because of your UA-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. :)
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.
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.
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!
wow, mindblown after the click of RUN, so convenient to learn Macro in 7 min, but I saw some comment saying that sorting is not applicable. So I start step by step learning based on video. And result really same as per others. Look back the macro, the sorting only apply to active worksheet (week1)... So our homework is to find out how to apply to current sheet, instead of just week1?
Thank you so much. I never even knew what a macro was until this. I created an Excel worksheet from QuickBooks and wasn't sure what to do when saving it and up pops a message about being macro enabled. Great help. If I ever find a little more time after tax season I may be back to click on that course. Adding to my Favorites bar right now.
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.
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
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!
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!
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
ua-cam.com/video/_87qfyAdeVk/v-deo.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!
ua-cam.com/video/_87qfyAdeVk/v-deo.html
Please check this one too and subscribe
I spend at least 30 minutes each morning in reports... I can’t thank you enough for this video gentleman
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 - ua-cam.com/video/BvDKxWnKJDc/v-deo.html
You have a calming voice and explain things clearly and at a moderate pace without fillers.
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.
Cody, man, you're still saving lives at 2022! Thanks for this video
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!!!! :'''''''''')
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!
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
Thank you Sir, my daily task finish in 5 mins now. All 3 reports
Fantastic instruction. Thanks so much! The sample file you included in the description below was very helpful by allowing me to follow along!
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
Incredible! I cannot believe how simple macros are! Thanks a bunch!
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.
Thanks a lot. It's a magic video for me. Just within 7 minutes, I grabbed the Macros. amazing 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.
Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you
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.
Woowoowoow, why did i learn macros just now? Such a powerful tool! Thanks a lot for this short yet very helpful 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
Thank you for your very clear, concise, and consistent teaching method.
I am absolutely paying whatever you're charging for your full course lol. This one skill was fantasmagorically life changing.
Great presentation! Not only were you very precise but your clear English and we'll spoken manner really helped!
Thanks my friend :) You are making my life much easier! God bless you!
You rocked it.... Hats off for your simplicity in this video...
The best, easiest and quickest explanation for an Excel tool that I have ever seen. Thanks!
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.
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 👌🏻
The best explanation of macros that I have found on youtube. Thanks
Excellent video! Brilliant. Well done. Easy to understand. Short. Precise. Clear. To the point. Useful. Much appreciated. Thank you.
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
Mother of … how amazing is how you show easy are macros. Thanks!
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).
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 :)
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.
Hi Cody, still relevant - 3 years later ! Thanks
Thank so much - I’ve struggled with macros & now you have dissolved the myth! Many many 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!
Mr.Baldwin, You are simply amazing. Thank you very much for this wonderful video. Your voice is pleasant to hear.
You are an excellent teacher, thank you. I’ll practice and do the lesson again
THIS WAS SUCH A BASIC YET EFFECTIVE VIDEO . THANK YOU
Truly, the simplest way of explaining Macros ! Very easy to understand and implement. Thanks Cody !
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!
Awesome explanation of macros, managed to put it to use right after watching the video! Thank you very much.
The way you make us understand the Macro is really awesome. Really Thanks to you!
Thanks!Finally someone explains it so simply !!! Everyone else just makes it messy and not clear
This guy makes things so simple
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!
I really like your calm and soft voice.
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!
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.
Amazing video. Much easier to understand than any other UA-cam. thank you
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!
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 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....
because of your UA-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! I finally understand what macros are.. And in just 7 minutes! Thanks!
Wow. Awesome video. Instant subscription. Thank you so much. Please make more excel tutorials.
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.
Omg, I truly did learn about macros in 7 minutes. Your teaching style is the best! Thank you
This was the very first time learning Macros. You made it so simple to understand! Thankyou so much!!
Got stuck on macros with an online course and this video was super helpful
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.
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
Helpful video for beginner and everyone, THANK YOU!
This is so straightforward and easy to understand. Thank you so much
Excellent. I really learned macros in 7 minutes. I applied in my work also
Thank you Cody you are super teacher. This is excellent.
This should be the blueprint to every tutorial ever
What a great explanation. Couldn't be clearer and more concise.
Very helpful. it made me understand where all te codes came from. Thank you!
Really unexpected i learnt macro by 7 min video.great work
today i learnt this by your easy explanation of your video will use this macro feature for sure in upcoming works
You have got one more subscribers.. You just nailed it bro in 7 minutes. Kudos. Well keep it up. Best wishes
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.
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!
For a beginner like me, you literally teach me many things such as the conditional formatting, sorting, etc.
Thank you Cody! I really appreciated this act of kindness :)
It seems the debt to income was not arranged according to highest to lowest.
ff
yea
I'm having the same issue with the D/I ratio not getting sorted for weeks 2 and 3. Amazing tutorial otherwise!
Any idea on why this is so?
wow, mindblown after the click of RUN, so convenient to learn Macro in 7 min, but I saw some comment saying that sorting is not applicable. So I start step by step learning based on video. And result really same as per others. Look back the macro, the sorting only apply to active worksheet (week1)... So our homework is to find out how to apply to current sheet, instead of just week1?
Excellent video. I used to fear the word "Macros" The fear is gone after watching your tutorial. Thanks a lot.
Thank you so much. I never even knew what a macro was until this. I created an Excel worksheet from QuickBooks and wasn't sure what to do when saving it and up pops a message about being macro enabled. Great help. If I ever find a little more time after tax season I may be back to click on that course. Adding to my Favorites bar right now.
If I had known how to use this in my past job that would have saved me hours. Thanks for this super simple tutorial.
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.
Thanks a lot for simple explanation. You made me learn all the more about it. Keep it up.
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
It is very helpful. Thank you for sharing this. I was using Excel and doing these kinds of tasks repeatedly. Macros help me a lot.
You are a natural teacher, soothing voice, great demo! Thank you so much, Cody! Subscribed. I need this for new job skills.
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 video !!! THE BEST PART is providing the right amount of info !!!!
omg, this is the best channel for teaching excel !!!
Amazing! gonna need this on my next task in our company what a very big help! thanks
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!