📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK Learn more about automating with Macros & VBA here: ua-cam.com/video/kdYWe0xkFKU/v-deo.html
Hi Kenji, I am in the final year of my engineering course, and this helped me in my design calculations and report. And got to learn a new thing. Thanks a lot.
Great beginner intro to VBA! I do, however, feel compelled to mention that "Merge and Center" is generally not considered best practices for more complicated workbooks.
@@Brenleysage merge And center makes your spreadsheet looks better. However, it will reduce the efficiency of data filtering. For example, if you merge Col A and B, then you will not be able to do a proper filter on Col A and B anymore.
@@LilYoda66 I'd say one of the main things you need to be able to do as a Business Analyst is to look at existing systems and how to improve and enhance them. That's what I do pretty much all day
Thank you Kenji for the informative video. I just wanted to add that VBA is not a tool, but rather a programming language. Great job by highlighting its capabilities!
@@KenjiExplains you are welcome boss! i have been following you for a long time. i Don't get that much time to practice all of your tricks but whenever i see your video, I don't waste time to do other things 💝 keep it up Boss!
Hey Kenji, thank you so much for all the videos. They are making a real difference. Stay the way you are (very authentic and with your energetic smile) and you will go very far with this UA-cam channel. A year (mostly 2 ) from now you will have a million subscribers.
You have great videos and I have learned very much by watching them. I have used VBA for some time for automation. There is one small mistake in the video. The code that You showed with "xlBottom" is vertical position of the text in merged cells (B2:G2) (the text is on the bottom of the merged cells). Argument for dynamical range is xlDown (or xlToRight if you go Ctrl+Shift+Right).
@@enderaslan7998 Agreed that it's not a small mistake. It really makes it seem like he doesn't really know what he's talking about. As for why it still works, using the ctrl+shift+arrow the recorder selects a new range from the original selection to the end of the data, so he is correct when he says that is the reason that it still works. As long as the data is consecutive you could add as many rows or columns to the ends as you want and it would still work fine, however if you move your data it would break.
This is awesome. I have to upload stocks and sales data on google sheets on a day to day basis, which requires quite a few formulas to convert dates and formatting cells. Im planning to make a master sheet on my pc where i could keep the data for each day using macros and then once the sheets are ready I can copy paste them on a new sheet and upload. Will try it tmrw and then edit my comment. Thanks alot.
Hey I'm definitely fish out of water here, i'm more mechanical and DIY than a tech person. But I definitely see use for this material in the long run. I'm a fan of learning in general (hence why i'm watching your videos, more information..) I see this being valid in future skills. Another fantastic part of this is crossing paths with ppl whom are waaay smarter than myself in these areas. Nothing like being a beginner somewhere new. I'm quite tech saavy for the fact that I recognized all your keystrokes and was able to follow with ease, altho i'm not familiar with exel. Complete beginner here for that program. Thank you for the video! I will definitely be watching more! Keep making excellent quality work. This was fantastic.
If you're not familiar with Excel, why would you need to learn macros? That's not me being snarky, it's a genuine question! I would recommend you to learn Excel first because what this is doing is automating what is just an Excel process.
Kenji- thanks for the great work! You make excel so much more accessible. Question:These macros work in this workbook and the buttons only work on the page you made them on. How will this help with next weeks "financials"?
You can choose to save your macro to "This Worksheet" or "personal worksheet". If you choose personal, then you can always access the recorded macro when working on different workbooks
WARNING: 2nd macro runs because he didnt click anywhere else after pressing record macro button! Anyone who mistakenly clicks anywhere else other than in the video, these macros will fail or worse (like "seem" as not working eventhough it does the same thing on a range already done). If you are creating a macro teaching video you must include: 1st step to record macros 2nd to explaining range selection 3rd do whatever you want, at least it wont be executed on wrong destination
I have to create an Excel data entry form with two conditions: 1) In the first form, I have to enter data in 5 cells and submit it. 2) In the second form, I have to enter data in 5 cells corresponding to the first form. Please provide the answer for above question with examples
at this point you really need to start dabbling into VBA or at least googling "how do I create a macro to [insert issue] in vba" and there are plenty of websites that provide you with stuff you can just copy and paste into a module
I am satisfied with macro actually, particularly it can help me completed my task until printing in document Form, such as Invoice, receipt, etc. I wonder if Power Query can asisst me until printing as macro did. Can anyone enlighten me?
Is it possible to autopulate different word documents from same spreadsheet? I mean, if there's a specific cell autopulate A.docx, otherwise b.docx, or c.docx etc...
Can you please help me with a query : Assuming I have data in Cell A15, A26, A30, A37, A44 and so on randomly Now I want to merge A1 to A15, A16 to A26, A27 to A30, A31 to A37, A38 to A44 and so on Can I automate this work ??
@KenjiExplains: In my excel I have header row starting row 6 and from number 7 row we have data in cells. I have a data in row 7 in columns a,e ,h,I,j that is calculated via a vlookup. Now I need that every time a data is entered in column E cells from row 8 , the data from row7 for columns a,h,I,j should be autopopulated in the row where we entered the data in column E . How to do this in excel using macro
I'm having difficulty creating a macro for a card flipping game in a PowerPoint presentation. The game consists of 14 cards (7 pairs), where the objective is to flip the cards to find the matching pairs. The specifications for card animations are as follows: Each card has a "Appear" entry animation with "On Click" trigger. Each card has a "Vanish" exit animation with "On Click" trigger. The cards are configured as follows: Each card is represented by two forms: one for the "Front" and one for the "Back". The "Front" shape is behind the "Back" shape on the slide. When clicked, the "Front" shape should disappear, revealing the "Back" shape, and vice versa. I tried to create a macro for this, but I faced difficulties correctly switching between the "Front" and "Back" forms, and controlling the entry and exit animations. I would like to ask for your help in creating a macro that meets these requirements. Any guidance, suggestions or code would be greatly appreciated. Thank you in advance for your collaboration and assistance.
Hi Would kindly asked you to make a video or send me any link regarding how to work with dates on excel sheet To format in such manner that it is possible to have in advance when the dates expires. Any help plz
📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK
Learn more about automating with Macros & VBA here: ua-cam.com/video/kdYWe0xkFKU/v-deo.html
Thanks!
Ty
Why is this one different than the one in the description Kenji?
I will have to watch frequently to understand more, thanks
I really appreciate your videos, which are very practical to understand and save our time , greetings from Timor-Leste
Hi Kenji, I am in the final year of my engineering course, and this helped me in my design calculations and report. And got to learn a new thing. Thanks a lot.
Glad it helped! Awesome to hear :)
I love Excel macros. I used a relatively simple one to automate individualized customer retention documents for our firm. Saves so much time.
Thank Kenji we don't learn this from school and the online course is expensive. Now I can experiment here on my PC.
Great beginner intro to VBA! I do, however, feel compelled to mention that "Merge and Center" is generally not considered best practices for more complicated workbooks.
Agree. Merge and center is a big no no
@@phonekl8441 how come?
@@Brenleysage merge And center makes your spreadsheet looks better.
However, it will reduce the efficiency of data filtering. For example, if you merge Col A and B, then you will not be able to do a proper filter on Col A and B anymore.
@@phonekl8441can’t you get a proper filter if you apply it to the column below
Cannot wait to create my first macro. Easy & precise directing 👍🏻👍🏻👍🏻
I just got offered a Business Analyst position and your videos are super helpful!
Same here. How’s it going for you? I’m retraining myself in excel and SQL. Any tips that have helped you the most?
@@LilYoda66 I'd say one of the main things you need to be able to do as a Business Analyst is to look at existing systems and how to improve and enhance them. That's what I do pretty much all day
Thank you Kenji for the informative video. I just wanted to add that VBA is not a tool, but rather a programming language. Great job by highlighting its capabilities!
bro need a playlist like basic to advance! you are great.
Noted thanks for the suggestion!
@@KenjiExplains you are welcome boss! i have been following you for a long time. i Don't get that much time to practice all of your tricks but whenever i see your video, I don't waste time to do other things 💝
keep it up Boss!
@@KenjiExplains Please let us know if you can curate one for us! Love this idea!
I subbed this channel because of keyboard-shortcutting. You have my respect.
Can you make a video on VBA too?
Will do depending on how this one performs :)
@@KenjiExplains i will watch as much as i can watch this video so that we can get more videos on VBA.
@@KenjiExplains what number of views is good performance for you?
@@KenjiExplains same question
@@rudrashishmajumdar4251 25 quadrillion
Best Explaination Ever
Hey Kenji, thank you so much for all the videos. They are making a real difference. Stay the way you are (very authentic and with your energetic smile) and you will go very far with this UA-cam channel. A year (mostly 2 ) from now you will have a million subscribers.
Super video! Short, well explained and easy to understand.
Good descriptions, thanks. I'd love to see one on how to easily export a macro so others can use it.
Giiirrrllll ima take naps at work! Thank yiuuuuu
You have great videos and I have learned very much by watching them. I have used VBA for some time for automation. There is one small mistake in the video. The code that You showed with "xlBottom" is vertical position of the text in merged cells (B2:G2) (the text is on the bottom of the merged cells). Argument for dynamical range is xlDown (or xlToRight if you go Ctrl+Shift+Right).
thats not a small mistake... and 2nd macro works just by luck : ))
@@enderaslan7998 Agreed that it's not a small mistake. It really makes it seem like he doesn't really know what he's talking about. As for why it still works, using the ctrl+shift+arrow the recorder selects a new range from the original selection to the end of the data, so he is correct when he says that is the reason that it still works. As long as the data is consecutive you could add as many rows or columns to the ends as you want and it would still work fine, however if you move your data it would break.
Thanks for this! That will save me big chunk of time everyday! Also thanks for the shortcuts. Value packed video! Subscribed
Thanks for such short but concise info
Nice video. Very clear. Thank You!
Gracias Kenji! Excelente video
thanks mate for your kindness to share
Thank you Sir... I was wondering how to save the file but you solved the problem just like a magic.. Thank you so so much!!😇
OMG, You are phenomenal, just phenomenal. Gracias.
Kenji, you the king
Great content, thank you!
This is awesome. I have to upload stocks and sales data on google sheets on a day to day basis, which requires quite a few formulas to convert dates and formatting cells. Im planning to make a master sheet on my pc where i could keep the data for each day using macros and then once the sheets are ready I can copy paste them on a new sheet and upload.
Will try it tmrw and then edit my comment. Thanks alot.
You are excellent. Very calming and professional to listen to. keep up the great work.
Thanks for the video Kenji!!!
bro! this is very helpful! thank you for this!
Hey Kenji, You are just awesome❤
Nice video, Kenji! I didn’t know I wanted to learn about Macros until I saw your video. Thanks!
Nice! Thank you! Improving my excel skills would greatly improve my job/work. I need to “excel” in this badly! Lol
Thank you that very useful info!
Hey I'm definitely fish out of water here, i'm more mechanical and DIY than a tech person. But I definitely see use for this material in the long run. I'm a fan of learning in general (hence why i'm watching your videos, more information..) I see this being valid in future skills. Another fantastic part of this is crossing paths with ppl whom are waaay smarter than myself in these areas. Nothing like being a beginner somewhere new. I'm quite tech saavy for the fact that I recognized all your keystrokes and was able to follow with ease, altho i'm not familiar with exel. Complete beginner here for that program.
Thank you for the video! I will definitely be watching more! Keep making excellent quality work. This was fantastic.
If you're not familiar with Excel, why would you need to learn macros? That's not me being snarky, it's a genuine question!
I would recommend you to learn Excel first because what this is doing is automating what is just an Excel process.
Excellent video,thanks.
Handsome teacher ❤
This is amazing stuff! Wow
Great as usual
Another new learning for me.... Thanks again Sir and more power...
This was very helpful! Thanks :)
Thank you for the video. Great to leaning!
Good Kenji 😊🙏
Good Job brother. Well explained :)
Kenji- thanks for the great work! You make excel so much more accessible. Question:These macros work in this workbook and the buttons only work on the page you made them on. How will this help with next weeks "financials"?
You can choose to save your macro to "This Worksheet" or "personal worksheet". If you choose personal, then you can always access the recorded macro when working on different workbooks
I highly recommend using personal folder and use a shortcut
Great going Kenji!
Appreciate your support :)
Thank you
thank you Kenji 🥰🥰
Thank you for watching Oscar!
Wish you best of luck.
Your videos are so easy to understand 😊✅
phenomenal video!
Awesome! Can use this to really automate some office tasks 👍
Absolutely!
Wonderful subscribed 🎉
Will you add Power BI lessons?
This was ace! Thanks Kenji
Thank you!
Will check ✔️ later
Sounds good!
Liked and subscribed!
Hi Kenji, we need more such videos on Dashboards Macros VBAs for beginners.. Thanks
Awesome video
What if the range of week 2 data is not same as week 1 data?
Will it work?
Really useful! Also very well explained!
Glad it was helpful!
Hi can you make a video series on financial modelling
WARNING: 2nd macro runs because he didnt click anywhere else after pressing record macro button!
Anyone who mistakenly clicks anywhere else other than in the video, these macros will fail or worse (like "seem" as not working eventhough it does the same thing on a range already done).
If you are creating a macro teaching video you must include:
1st step to record macros
2nd to explaining range selection
3rd do whatever you want, at least it wont be executed on wrong destination
Hi Kenji,
As usual, thanks for the informative tutorials. Would you do a tutorial on VBA please?
When adding a new macro there is a shortcut option underneath where you name the macro so there is no need to make a button 3:56
Do you have tutorial on how to locked cells and Sheet in macro? please. i have a hard time to understand how to do it.
Really cool action :))
thank you!
I noticed you did everything with keyboard shortcuts. Can it work with actual clicking as well?
for the Highlight macro, there is an alternative: Styles
Thanks for the video. Can we use macro to link to external app like SAP?
bring more videos on investment banking and finance.
I have to create an Excel data entry form with two conditions: 1) In the first form, I have to enter data in 5 cells and submit it. 2) In the second form, I have to enter data in 5 cells corresponding to the first form.
Please provide the answer for above question with examples
Good content! For the first example, what if you recieve the same data every week but on different cells?
Hey Jose, though question, I think the easiest would be to move the data to the equivalent spot (like always the first cells on Excel)
at this point you really need to start dabbling into VBA or at least googling "how do I create a macro to [insert issue] in vba" and there are plenty of websites that provide you with stuff you can just copy and paste into a module
So the shortcuts you use, are they for Windows? Are they the same for Mac users?
Great video👍.
But if theres a macro embedded in excel, will that be a problem if you import that file into Power BI?
@Kenji - how do you select the colours? I know alt+H,H and N work for no fill but choosing the colour doesn't work. How do you do it ?
Merge+Center is egregious.
Center Across Selection is far superior.
macross i getting obsolete as power query is taking over
Main drawback of using macro is it makes your file very bulky specially when you use multiple macros in a single file
Thanks for this valuable Video ❤ just one help, What is the tool or program using to record this high quality video?
I am satisfied with macro actually, particularly it can help me completed my task until printing in document Form, such as Invoice, receipt, etc. I wonder if Power Query can asisst me until printing as macro did. Can anyone enlighten me?
Sometimes clicking the button is actually faster than keyboard shortcut
Do you have videos on how to run macros or vba on protected sheets?
5:49 ...why applying this macro doesn't 'bolden' the row ?
Is it possible to autopulate different word documents from same spreadsheet? I mean, if there's a specific cell autopulate A.docx, otherwise b.docx, or c.docx etc...
Hi. I do not get the part in which is dynamic when the size change. Could you elaborate a little more please?
Can you create a macro that turn one csv file format into another. Bascall move the colums around ?
Hii...thank you very much...we need some help for our students...pls help us.. provide us a chat or communication method
Can you please help me with a query :
Assuming I have data in Cell
A15, A26, A30, A37, A44 and so on randomly
Now I want to merge A1 to A15, A16 to A26, A27 to A30, A31 to A37, A38 to A44 and so on
Can I automate this work ??
@KenjiExplains: In my excel I have header row starting row 6 and from number 7 row we have data in cells. I have a data in row 7 in columns a,e ,h,I,j that is calculated via a vlookup. Now I need that every time a data is entered in column E cells from row 8 , the data from row7 for columns a,h,I,j should be autopopulated in the row where we entered the data in column E . How to do this in excel using macro
Yes kenjiiiiii
Cheers Tristan!
Where should I apply? Thanks!
I'm having difficulty creating a macro for a card flipping game in a PowerPoint presentation. The game consists of 14 cards (7 pairs), where the objective is to flip the cards to find the matching pairs.
The specifications for card animations are as follows:
Each card has a "Appear" entry animation with "On Click" trigger.
Each card has a "Vanish" exit animation with "On Click" trigger.
The cards are configured as follows:
Each card is represented by two forms: one for the "Front" and one for the "Back".
The "Front" shape is behind the "Back" shape on the slide.
When clicked, the "Front" shape should disappear, revealing the "Back" shape, and vice versa.
I tried to create a macro for this, but I faced difficulties correctly switching between the "Front" and "Back" forms, and controlling the entry and exit animations.
I would like to ask for your help in creating a macro that meets these requirements. Any guidance, suggestions or code would be greatly appreciated.
Thank you in advance for your collaboration and assistance.
Hi
Would kindly asked you to make a video or send me any link regarding how to work with dates on excel sheet
To format in such manner that it is possible to have in advance when the dates expires.
Any help plz
loving it
I tried your method and it works, but it added the old data and new data. How do I create it to only update the spreadsheet with new data?
When you renamed the button you highlighted the words in front of what you renamed the button how did you do that?