Introduction to Excel Macros - Record your first Macro in Excel (plus free e-book)
Вставка
- Опубліковано 11 лип 2024
- // FREE Excel E-book "Record Your First Macro"
→ www.launchexcel.com/record-yo...
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
--
// EPISODE NOTES
In the first video of this series I will:
▸ Reveal the hidden ribbon tab that allows you to start developing Macros in Excel (this is a secret that most Excel users never learn!)
▸ Take you through the Launch Excel 3-stage formula for Recording your First Macro in Excel
▸ Show you how to create a simple Macro that you can use to audit your worksheets
▸Teach you a super speedy shortcut method for playing back your Macros
▸ You will learn how easy it is to start using Macros to automate Microsoft Excel.
--
// LEARN MACROS WITH LAUNCH EXCEL
Most Excel users never start using Macros because they either haven't heard of them, or feel overwhelmed because they think it's all too hard. This is a shame because Macros and VBA can give you Excel superpowers.
You can save vast amounts of time by automating repetitive tasks and even create your own new functionality to do things that Excel does not do by itself.
But... it sometimes looks like Excel Macros are so technical. Don't worry, in this video I will talk you through step-by-step how to record your very first Macro.
--
// VISIT MY WEBSITE
For more awesome tutorials on Microsoft Excel visit my website → www.launchexcel.com - Навчання та стиль
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!
Thank you for your upload it's been super helpful for my school work.
Great video. Very easy to follow!
THANK YOU SO MUCH. SUBSCRIBED
very useful and informative video
Your videos are super informative! I very much like learning from you please keep posting videos!
Thanks Fuzzysuperpi
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!
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.
Great tutorial
thank you!! This is a great excel tutorial for freshgrad
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.
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
how can i download this sheet to practice?
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 UA-cam: 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.
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.
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 UA-cam 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 😀