Thank you for watching my video. Get your free e-book at the following link: DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook Please leave a comment below with any questions you have about getting started with learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
Hi, thank you for helping me, I am learning lots of new things about Microsoft 365 as studying "Business Administration". It's all very tricky so would be great to get your book as practice makes perfect.
Hi Gopala Krishna Thanks for commenting. Yes I will add more videos about Macros and VBA. I plan to focus on helping beginners learn how to use Macros and VBA. If you have any specific request just post a comment - I do my best to read all comments but may not be able to reply to all.
I have 3 sheets 1 sheet contains details of the clients that walked in at the site 2nd sheet contains the details of the clients i went to meet Now I have three questions 1) want to use macro to make a master sheet that would contain details of all the clients from sheet 1 & 2 2) how can the master get updated as & when I update the sheets individually using macro 3) how do i use 'if function'" or macro that would paste a particular colored row automatically to a different sheet when the colour of the row changes M not good at VBA
Upload the Link to the excel file you are working in the file so that we can download the file and start working with you while watching the video for better understanding.
Hi Reec... sorry to hear you had trouble getting the E-book. Can you send me a private message and I'll help you personally? Here's how to send a message on RUclips: support.google.com/youtube/answer/57955?hl=en
Is it possible to create a macro that copies information from one file into another file, then replaces some of the copied text with text from another file?
Sure, that is definitely possible with VBA and Macros. If the copy/paste action is identical every time, then you can record a macro that does the job and replay it over and over. But if the copy/paste range(s) or workbook(s) or worksheet(s) changes each time you perform the operation, then you will need to code in VBA.
Hi toxicwaste920... sorry to hear it didn't work for you. I'd like to check whether you tried using the saved macro on new data in a new workbook? One that's different from the workbook you saved? To save a Macro and use it across different workbooks (not just the one it's saved in) you'll need to store the macro in your Personal Macro Workbook. Here's a Microsoft article that shows how: support.office.com/en-us/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790
Launch Excel yes, i thought once its saved, i can use it on a new one workbook? I guess it doesn't work that way. I will check that link you sent. Thanks. I am new at this.
Alright - to clarify - if you save a Macro to one workbook then it can only be run when that workbook is open. If you want to create a Macro that works across all the workbooks on your copy of Excel, you can add the Macro to your Personal Macro workbook (more advanced Excel developers also write add-ins that work across workbooks) The Personal Macro workbook stays open in the background when you start Excel... so the Macros stored in it can be accessed. Hope that helps ... and I encourage you to keep learning Macros & VBA. I know the learning curve can be steep... and you'll definitely come across frustrating moments... but if you stick with it, the payoff is very satisfying. - Victor (Launch Excel)
Launch Excel thanks, yes, i figured it out, i copied the data on that workbook and the macro i saved worked. I will try that personal macro workbook next time. I appreciate your explanations.
Hey I'm glad you worked out how to do that! I think it's great that you're trying and hope you keep learning Macros & VBA - it's a great skillset to have. Cheers - Victor
Hi Maggie - Thanks for your feedback. I'll consider it for future videos. In the mean time, you can use RUclips settings to increase the speed (up to 2x). I personally play a lot of videos at 1.25x speed. Cheers, Victor
Thank you for watching my video. Get your free e-book at the following link:
DOWNLOAD EBOOK → launchexcel.lpages.co/first-macro-ebook
Please leave a comment below with any questions you have about getting started with learning Macros and VBA for Excel. And click on the LIKE button if you found this video helpful. Thanks for supporting my channel!
Hi, thank you for helping me, I am learning lots of new things about Microsoft 365 as studying "Business Administration". It's all very tricky so would be great to get your book as practice makes perfect.
Thank you for your upload it's been super helpful for my school work.
very useful and informative video
Great video! Thanks for opening up the world of macros!
Hi Carol. I appreciate your comment! Yes, welcome to the world of Macros and VBA. I hope you'll find it exciting and useful!
Your videos are super informative! I very much like learning from you please keep posting videos!
Thanks Fuzzysuperpi
Great video. Very easy to follow!
THANK YOU SO MUCH. SUBSCRIBED
Thanks very useful and informative. What about the other chapters? In the next videos? Please upload. very very thanks.
Hi Gopala Krishna
Thanks for commenting. Yes I will add more videos about Macros and VBA. I plan to focus on helping beginners learn how to use Macros and VBA. If you have any specific request just post a comment - I do my best to read all comments but may not be able to reply to all.
Great tutorial
thank you!! This is a great excel tutorial for freshgrad
I have 3 sheets
1 sheet contains details of the clients that walked in at the site
2nd sheet contains the details of the clients i went to meet
Now I have three questions
1) want to use macro to make a master sheet that would contain details of all the clients from sheet 1 & 2
2) how can the master get updated as & when I update the sheets individually using macro
3) how do i use 'if function'" or macro that would paste a particular colored row automatically to a different sheet when the colour of the row changes
M not good at VBA
Upload the Link to the excel file you are working in the file so that we can download the file and start working with you while watching the video for better understanding.
Thanks for the video, am not able to to get the E-book after confirmation of the subscription. May you advise on how I can get it please.
Hi Reec... sorry to hear you had trouble getting the E-book. Can you send me a private message and I'll help you personally?
Here's how to send a message on RUclips: support.google.com/youtube/answer/57955?hl=en
how can i download this sheet to practice?
Is it possible to create a macro that copies information from one file into another file, then replaces some of the copied text with text from another file?
Sure, that is definitely possible with VBA and Macros.
If the copy/paste action is identical every time, then you can record a macro that does the job and replay it over and over. But if the copy/paste range(s) or workbook(s) or worksheet(s) changes each time you perform the operation, then you will need to code in VBA.
kindly zoom in to excel during video recording.
Kinan - Thanks for your feedback. I'll remember to do so for future videos.
Shit does not work. Tried saving the macro, then I tried to use the saved macro on a new data, DID NOT WORK!!!!!!
Hi toxicwaste920... sorry to hear it didn't work for you. I'd like to check whether you tried using the saved macro on new data in a new workbook? One that's different from the workbook you saved?
To save a Macro and use it across different workbooks (not just the one it's saved in) you'll need to store the macro in your Personal Macro Workbook.
Here's a Microsoft article that shows how:
support.office.com/en-us/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790
Launch Excel yes, i thought once its saved, i can use it on a new one workbook? I guess it doesn't work that way. I will check that link you sent. Thanks. I am new at this.
Alright - to clarify - if you save a Macro to one workbook then it can only be run when that workbook is open.
If you want to create a Macro that works across all the workbooks on your copy of Excel, you can add the Macro to your Personal Macro workbook (more advanced Excel developers also write add-ins that work across workbooks)
The Personal Macro workbook stays open in the background when you start Excel... so the Macros stored in it can be accessed.
Hope that helps ... and I encourage you to keep learning Macros & VBA. I know the learning curve can be steep... and you'll definitely come across frustrating moments... but if you stick with it, the payoff is very satisfying.
- Victor (Launch Excel)
Launch Excel thanks, yes, i figured it out, i copied the data on that workbook and the macro i saved worked. I will try that personal macro workbook next time. I appreciate your explanations.
Hey I'm glad you worked out how to do that! I think it's great that you're trying and hope you keep learning Macros & VBA - it's a great skillset to have.
Cheers
- Victor
you might try talking a bit faster and louder you are dragging it out too long
Hi Maggie - Thanks for your feedback. I'll consider it for future videos. In the mean time, you can use RUclips settings to increase the speed (up to 2x). I personally play a lot of videos at 1.25x speed.
Cheers,
Victor
Talks to much but not Important ones.
Thanks for your feedback. I'm looking to improve. Let me know what you'd like to see. I'll see if I can deliver 😀