Master Excel MACROS & VBA in ONLY 1 HOUR!

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 320

  • @hewalker14
    @hewalker14 5 лет назад +31

    I found this extremely Helpful. I am going for a new job and they asked if I knew macros after this session I feel confident that I can do this job to the fullest

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад +3

      WOW that is awesome Holley! Let us know how you get on with the job interview and I am sure that you will do well :)

  • @MyExcelOnline
    @MyExcelOnline  4 года назад +1

    💻Access 1,000+ Microsoft Excel video training tutorials covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE! JOIN TODAY TO ADVANCE YOUR EXCEL SKILLS 👉 www.myexcelonline.com/107-42.html

  • @jam-hu
    @jam-hu 6 лет назад +23

    jump straight to 4:10 to skip the orga stuff at the beginning. Great Video. Thanks a mil.

    • @rafie004
      @rafie004 5 лет назад +2

      4:24 to be exact but thanks!

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Hey Jamal, Glad you liked this Excel Macros & VBA tutorial!

  • @amirwisal3364
    @amirwisal3364 3 года назад +8

    Been trying to learn VBA from RUclips. Watched tons of videos but this one actually was awesome. Thank you ❤️

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      That's great! Thanks for the positive feedback!

  • @DanielNelson320
    @DanielNelson320 3 года назад +2

    I used to hate coding before, Aftr watching this detailed explanation I started liking coding ,hope I can master in VBA

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Practice makes perfect Rachel, keep on Excelling!

  • @Johnsiri
    @Johnsiri 3 года назад +12

    I think It’s not easy to simplify this , but you did it so well. Thank you very much.

  • @fw3901
    @fw3901 6 лет назад +11

    this is amazing thanks! I watched this video for 5min(with fast forwarding) and then went ahead to build a simple VBA macro for work! I thought it's gonna take me much longer...Awesome information, thanks!

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад +2

      Hey FW, Glad you liked this Excel Macros & VBA tutorial!

    • @vinodhkumar4878
      @vinodhkumar4878 2 года назад

      Sir can u help me I have one file that I need different format to make macro ....plz hlp me sir

  • @davidbe21
    @davidbe21 2 года назад +1

    the way you teach makes it so easy to understand , thank you .

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      You are welcome! Thanks for the compliment!

  • @TheJoshtheboss
    @TheJoshtheboss 2 года назад +4

    1st time looking into Macros. Wasn't sure which video to start with. Glad I started with the right one! Excellent work! Thank you.

  • @tapansaha6624
    @tapansaha6624 2 года назад

    Hi ,I went though a lot of video in you tube and found your explanation is very simplest way, Thank you Kyle.

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Oh, thank you! We try hard to make videos easy for everyone to understand.

  • @MuhammadImran-sn9lq
    @MuhammadImran-sn9lq 2 года назад +6

    Thank you John & Kyle. It was really amazing; Mr. Kyle did an awesome introduction to Macros and VBA. God bless you both.

  • @tonyperkins5163
    @tonyperkins5163 11 месяцев назад

    This guy is an AWESOME TEACHER!

  • @ugonnac8937
    @ugonnac8937 2 года назад

    Wow! one of the clearest explanations of VBA code. Thanks a lot

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Glad it was helpful! Thanks for watching.

  • @massefromla2554
    @massefromla2554 3 года назад

    Nice personality , clear and professional.

  • @diachpriscilla6154
    @diachpriscilla6154 3 года назад +1

    I like this so much and it's one of my best videos on youtube

  • @jTab8039
    @jTab8039 5 лет назад +9

    Nice introduction to macros and VBA code. I understood the coding itself but I often had trouble understanding looping. Your explanation of the "do while" looping code was easy to understand and now I feel confident I could use it in a similar circumstance. Thanks !!

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      We are glad that you were able to learn the "do while" looping and become more confident in Excel VBA!

    • @ahmednavivwala1707
      @ahmednavivwala1707 Год назад

      5:25

  • @narendrababumc6629
    @narendrababumc6629 Год назад

    very nice and much helpful in learning VB macros. Thank you so much..

  • @sml4126
    @sml4126 Год назад

    I have just found your site and this is exactly what I was looking for for sometime now. I consider myself an intermediate user of Excel but I want to improve my knowledge from a certified organisation such as yours. Please let me know if this online training offer is still in effect today. Thank you.

    • @MyExcelOnline
      @MyExcelOnline  Год назад

      Sure! Check out our website at myexcelonline.com as we have many different options under the Courses menu. Hope you find one helpful to you!

  • @bankinterbankinter
    @bankinterbankinter 2 года назад

    Hi, this is a good vba Page.
    I suggest these useful macros:
    Workbook route in title bar
    Workbook name in title bar
    Highlight active cell
    Highlight active row & column
    Color tabs - worksheets
    Uncolor tabs - worksheets
    Number to letters

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Thanks for the tips! Those ARE good macros.

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      And check out our site for more macros: www.myexcelonline.com/137-42.html

  • @enockoloo3814
    @enockoloo3814 Год назад

    clear so professional and awesome - great job bro.

  • @bhal756
    @bhal756 2 года назад +1

    Great Job Buddy . Extremely helpful..

  • @vlogbossku8470
    @vlogbossku8470 4 года назад

    really thanks to god..i ve seen a lot video but your video i can understand very much better..really love u a lot a lot..big thumbs up from malaysia

    • @MyExcelOnline
      @MyExcelOnline  4 года назад

      You are most welcome and glad you learned how to use Macros & VBA to automate your Excel worksheets & reports!

  • @lookingforwardto
    @lookingforwardto 2 года назад

    Nice content . Nice presentation with clear workable english. Excellent trainer & his knowledge..

  • @RW-td2hz
    @RW-td2hz 5 лет назад +7

    Wow, I never thought I would get excited about coding but this is really cool.

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад +1

      Welcome to the exciting world of coding Roger :)

  • @vc8836
    @vc8836 4 года назад

    Why didnt i find you guys earlier.... Blessing in disguise... I learnt so much from your channel and amazing training video... Totally nerdy ;)

    • @MyExcelOnline
      @MyExcelOnline  4 года назад

      That’s awesome to hear VC! Feel free to share our channel with your friends 👍

  • @bigbrother_M.N.A
    @bigbrother_M.N.A 2 года назад

    thanks dude, now monthly work, will finish in 1 day

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      It’s possible with Macros & VBA!!!

  • @osham5206
    @osham5206 5 лет назад +3

    Such a simple and professional way to understand Macros, you're awesome guys. BEST Luck to you :)

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Thanks for your comment and feel free to share this with your friends and colleagues :)

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive 2 года назад

    Thanks for the knowledge shared....

  • @idowubusari4453
    @idowubusari4453 5 лет назад

    EASY ....ITS FLOWS ... YOUB ARE INDEED AN EXCEL TEACHING ANGEL

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Thank you for your nice comments Idowu!

  • @Chris_D_Chun
    @Chris_D_Chun 5 лет назад +3

    This is gold. very helpful thank you

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      You are welcome Chris and make sure to check out our other awesome Excel tutorials on our RUclips channel and over at www.myexcelonline.com/blog/

  • @natepfunk
    @natepfunk Год назад

    This is really good info. Thanks!

  • @Seftehandle
    @Seftehandle 2 года назад

    I really liked this presentation easy to follow through

  • @ahmedshaat9968
    @ahmedshaat9968 2 года назад

    Man you are the best thank you for your efforts!

    • @MyExcelOnline
      @MyExcelOnline  2 года назад +1

      My pleasure! So glad you found this helpful!

  • @reyo9377
    @reyo9377 2 года назад

    Thanks you are good at it

  • @karenmcpoyle687
    @karenmcpoyle687 5 лет назад

    Excellent course. Very clear and organized.

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Thanks Karen and I hope that Macros & VBA are much easier to you now!

  • @mmmandyzhu9092
    @mmmandyzhu9092 5 лет назад +49

    Good video, and I recommend watching at 1.25x speed.

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад +1

      Thanks for your feedback and that is a great tip!

    • @Youssiflagrosse
      @Youssiflagrosse 5 лет назад +3

      1.5 is fine too. I was dying... Thanks for the tip.

    • @ziadabdat6232
      @ziadabdat6232 5 лет назад

      Thank you for the tips,

    • @naomilago
      @naomilago Год назад

      I'm watching at 2x and it's fine now

  • @soundpassion-africa2874
    @soundpassion-africa2874 5 лет назад +1

    You are a great teacher. Thanks for the training

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      I hope you learned a lot of new Excel & VBA tips!

  • @healthvidspnoy1599
    @healthvidspnoy1599 3 года назад

    Nice video, I have learned new knowledge from the webinar. But the thing, this is only an introduction. lol

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Great! Glad you now want to learn more. Check out our website and blog at www.myexcelonline.com/blog/ to learn even more!

  • @vikaasb2016
    @vikaasb2016 2 года назад

    Awesome ! Your former student Kyle !!

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi Kyle! Glad to see you are still using Excel! Thanks for responding!

  • @sainidhi009
    @sainidhi009 4 года назад +1

    This is excellent material! Do you have the part 2 of this course on youtube please??

    • @MyExcelOnline
      @MyExcelOnline  4 года назад

      Hey Sitara, we have more VBA tutorials over at our Academy online course here: www.myexcelonline.com/academy/enroll-eg/

  • @sushmithan1795
    @sushmithan1795 3 года назад

    Amazing teaching

  • @143ranagu
    @143ranagu 3 года назад

    Hi John,
    I would like to learn VBA macros more. Could you please share us more videos which is help us to learn VBA in depth.

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Here we have 101 Macros for you: www.myexcelonline.com/blog/101-excel-macros-examples/

  • @terenceulani668
    @terenceulani668 3 года назад

    don't really know the magic was there in the excel .Thanks a lot to let me know..really appreciate the video

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      You are very welcome. Excel IS magical! And really fun to use!

  • @stardust7183
    @stardust7183 3 года назад

    You guys are GREAAAAAAAAAAAAAT

  • @sandeepkothari5000
    @sandeepkothari5000 6 лет назад +3

    A wowsome webinar!

    • @MyExcelOnline
      @MyExcelOnline  6 лет назад

      Glad you enjoyed this Excel Macros & VBA tutorial Sandeep! Feel free to share with your friends :)
      Cheers,
      John

  • @moseshunui7767
    @moseshunui7767 5 лет назад

    so wonderful to follow to master VBA and Macros

  • @gandharsakpal9527
    @gandharsakpal9527 2 года назад

    Hi the Video was too informative all i wanna ask is that if i want to for eg add a month July to my worksheet and then copy the july and paste till the end of the range and then i use the same macro in the other excel sheet where the is longer than this worksheet what can i do in order to get the data till the end of the range of the new excel worksheet

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi. Thanks for the question. Can you see the original range? If it ends in say Cell D50, just edit the D50 to the end of your new range (the cell with the end of where the July that you added is). If that doesn't answer your question, please respond in more detail.

  • @brendachokera8307
    @brendachokera8307 6 лет назад +3

    Well done Kyle, thanks!

  • @thatounchained9794
    @thatounchained9794 5 лет назад +2

    Loved it!!!!!

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      I am glad you enjoyed our Macros & VBA tutorial Thato!

  • @siafawejumomo1724
    @siafawejumomo1724 5 лет назад +1

    Thanks , Love this video

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Im glad you enjoyed this Macros & VBA tutorial Siafa :)

  • @Soham650
    @Soham650 3 года назад

    It's extremely helpfull. If you show me how we can assign any job into among some employees by using vba. It will be more helpful for me

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hi! Thanks for the feedback. Check our blog at www.myexcelonline.com/blog

  • @deepasawlani9867
    @deepasawlani9867 2 года назад

    The concepts are shown so very clearly. I would lie to learn about VBA coding and macros to develop automated dashboards. Could you please guide me. Thank you !

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      We have a dashboard series AND a VBA series if you'd like to check them out.

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      ruclips.net/video/V6bLATFw4Vw/видео.html

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Also, there's an intro to dashboards in this playlist, towards the bottom: ruclips.net/video/vA2NiYiGkgs/видео.html

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      And if you don't find what you need there, please check out our blog: www.myexcelonline.com/blog/

  • @godrichotchey7648
    @godrichotchey7648 2 года назад

    Wow! that's great

  • @georgeneamodia7240
    @georgeneamodia7240 2 года назад

    Thank you do much!

  • @logicalighting6491
    @logicalighting6491 3 года назад

    Hello, I want to watch this video once more before I sign up for the course. Please send me a link so I can download it and watch it. I'm 79 and it takes me longer to catch on to this stuff. Thank you for the great session.
    thanks,
    Jim

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hey Jim, unfortunate the video is not downloadable but you can watch it as many times as you like here 😀

  • @prernaaggarwal
    @prernaaggarwal 4 года назад

    Thanks for the informatory videos...well explained :)

  • @baumulo
    @baumulo 3 года назад

    Beautiful. Thank you.

  • @janetcheong2121
    @janetcheong2121 Год назад

    Hello, is this course still offer those bonuses mentioned? I'm interested, but I don't know if I will still get the same value for the course. Please let me know. Thanks!

    • @MyExcelOnline
      @MyExcelOnline  Год назад

      Hey Janet yes it does! Just go to our website myexcelonline.com and drop us an email there. We will get you setup asap! 💚

  • @mauriciomunozortiz
    @mauriciomunozortiz 5 лет назад +1

    Thank you indeed for this video, very helpful.

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      I'm glad you enjoyed this Macros & VBA tutorial Mauricio!

  • @mr.a_a9407
    @mr.a_a9407 3 года назад

    Thank you so much.

  • @walekalejaiye5488
    @walekalejaiye5488 3 года назад +2

    This is very useful, clear and very precise. Do you have other tutorials like this either in Python, R, Data Science, Data Analytics, ML, or SQL

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Unfortunately we don’t have those specific courses at the moment

  • @yuval_kahan
    @yuval_kahan 2 года назад

    Thanks you very much blue men!
    🎶im blue if i was green i was die🎶

  • @explorerstudio305
    @explorerstudio305 3 года назад

    This was a great webinar for introduction on Macros and VBA.
    Obviously no one can master it in 1hour, if that was the case everyone would 😂

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      You are correct! Hopefully it was enough to get you interested in VBA.

  • @md.zahidulislam9067
    @md.zahidulislam9067 3 года назад +1

    Dr Manhattan is teaching us Macros/VBA

  • @NakedBandito247
    @NakedBandito247 4 года назад +1

    Very helpful, but definitely watch at 1.25x speed, otherwise it's gonna be a long watch

  • @sday2551
    @sday2551 Год назад

    New to macros and looking to export data from sheet 1 to sheet 2, but only pulling through certain columns, and changing the data in those columns when it lands in sheet 2. Any ideas?

    • @MyExcelOnline
      @MyExcelOnline  Год назад

      It might be better for you to use Power Query, as PQ is perfect for data transformations.

  • @marko77188
    @marko77188 9 месяцев назад

    If anyone know other Kyle's tutorials pls make a list

    • @MyExcelOnline
      @MyExcelOnline  9 месяцев назад

      Hi. Yes, we have a complete set of Kyle's tutorials here: join.myexcelonline.com/

  • @moesadr3342
    @moesadr3342 2 года назад

    What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Thanks for the question. Are you asking how you know a workbook has VBA? It should have a .xlsm extension with the m being for macro. You can upload it and share it in OneDrive or SharePoint. If Sharing, SharePoint may be better. Hope that helps!

  • @laoer_9949
    @laoer_9949 6 лет назад +1

    This is awesome!

    • @MyExcelOnline
      @MyExcelOnline  6 лет назад

      Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
      Cheers,
      John

  • @sk_abdul
    @sk_abdul 2 года назад

    Hey, please help in VBA Codes for the work, i have workbook with 2 sheet, data available in sheet1 and same header available in sheet2, and the code should work for it will match the header and pull the data from sheet 1and paste it in sheet2 as per the header matched. if you share the code it will help me more. thanks

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi. Thanks for the question. That's a little more complicated that we could help with in a comment, but we have a consulting service that could help you. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/

  • @SomnoNaut
    @SomnoNaut 5 лет назад

    I find it best to try and write the logic longhand in comments within cells that I would like to see in my workbook. How do others visualize the processes that they envision for their workbooks?

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Thats a great way of doing things Claude! Each person has their own unique way of doing things inside Excel so they can easily remember how to get to a result :)

  • @musacwengasotashe6766
    @musacwengasotashe6766 3 года назад

    This ìs really greàt

  • @bernardbomai
    @bernardbomai 11 месяцев назад

    Hi, what is the technic! when sheet 1 entry sheet was complete and recorded, applying to database worksheet sheet 2 to record all rows isn't work please assist.

    • @MyExcelOnline
      @MyExcelOnline  11 месяцев назад

      Hi. Thanks for the question. Could you please let us know the timestamp in the video where you are having issues? Thank you.

  • @fengfuxu4822
    @fengfuxu4822 10 месяцев назад

    thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers".
    Sub ListPrinters()
    Dim prt As Printer
    For Each prt In Printers
    Debug.Print Printer.deviceName
    Next prt
    End Sub

    • @MyExcelOnline
      @MyExcelOnline  10 месяцев назад

      Go to Tools -> References and make sure that Microsoft Access Object Library is checked.

  • @anastasiiachabanenko576
    @anastasiiachabanenko576 4 года назад

    thank you for this!!

  • @shivanica
    @shivanica 3 года назад

    Thank you so much for the video. It was really helpful. I have a question, to ask you.
    If I have to copy a set of cells every day from a set of worksheets into a notepad and save that notepad datewise, is it possible to use macros or VBA? Please help.

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      You can create a filesystemobject and use the CreateTextFile method. Also, visit our blog for lots of tips: www.myexcelonline.com/blog/

  • @girishalur5819
    @girishalur5819 2 года назад

    I have 2 questions.
    1. How to define live month in in excel macro?
    2. How to create dynamic filter?

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      you can use the MONTH function to get the current month. Check our blog for more info: www.myexcelonline.com/blog/

  • @abhishekverma2833
    @abhishekverma2833 3 года назад

    Hi I am Abhishek from India I want to learn VBA Coding but it's looks difficult to learn Coding how I would learn these code ?

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hi Abhishek! You could create a Macro under the View ribbon. And you can run the macro by selecting Macro|Run Macro. The macro IS VBA code. You could use it for things that aren't possible to do with a formula, like looping through cells until yo find a certain value or for processes you would do over and over again to automate them. It's a great language because it's not a hard one to learn. Check out our blog for more at www.myexcelonline.com/blog/

  • @mojahids.hadjisiddique8747
    @mojahids.hadjisiddique8747 3 года назад

    thanks! Loud and clear

  • @mariannruiz7846
    @mariannruiz7846 2 года назад

    Useful

  • @nicolewagner3267
    @nicolewagner3267 6 лет назад +1

    kyle you ROCK!

    • @MyExcelOnline
      @MyExcelOnline  6 лет назад

      Glad you enjoyed this Excel Macros & VBA tutorial for beginners!
      Cheers,
      John

  • @NotAnAIpromise
    @NotAnAIpromise 3 года назад +2

    Mom: So what'd you do today?
    Me: Learned Macros from the blue man
    Mom: What did we say about lying?
    Me: Mom(1).Delete

  • @paranthamanadthiya2710
    @paranthamanadthiya2710 2 года назад

    Hi how wpuld you find the percentage of two sheets in macro

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi. Thanks for writing! Could you please clarify what percentage you would like?

  • @wasaytauqir213
    @wasaytauqir213 3 года назад

    Thanks for the video
    Can YOU please explain how to remain sheets using the VBA code when we want to rename each sheet a different name?
    I tried Activesheet.Name code after 1st sheet name but it gives error
    Do YOU guys have any video on that or anyone else can help?

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hi Wasay. Do you have a copy of the code you are trying? Sometimes it is found in Worksheets("name of sheet") . You can try that.

  • @TorqueDemo
    @TorqueDemo 2 года назад

    Good Day sir,
    Hope you can help. We had an employee leave the company and he changed the passwords fo rthe VBA editor on all of our templates. He had taken most of our templates and removed the menu bars and ribbons. We cant even use the undo feature. is there a way to find the password or remove it at least?

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi Colin. Yes there is a way. This video is actually on our list of one to make soon. It's a little involved, but you can do it.
      First, make a backup of your Excel workbook and save it to another folder just in case you make a mistake. Then work with either the iriginal file or the back up and do the following:
      1. Change the extension of the protected worksheet: rename it from *.xlsx to *.zip.
      2. Open the ZIP File, double-click the "xl" folder, and then open the "worksheets" folder.
      3. In there, you can find the spreadsheets (in .xml format).
      4. Open a sheet file in Notepad. Now search for the content:

  • @danielonyedikachiokwandu8295
    @danielonyedikachiokwandu8295 3 года назад

    Please is VBA and MACROS needed for Accountants or Financial analysts?

    • @ireenj6593
      @ireenj6593 3 года назад

      Yes, using alot

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      There are a lot of great functions for Financials in Excel, but as in all things, VBA allows you to do even more.

  • @andrewle9313
    @andrewle9313 2 года назад

    nice

  • @Stephanie-b2m1d
    @Stephanie-b2m1d Год назад

    Can I record a ctrl+replace. I want to be able to hit a button and it replaces all of this year (year inputed in a certain cell) with next year (year put in another cell) but ctrl replace doesn't seem to be able to take info from a certain cell

    • @MyExcelOnline
      @MyExcelOnline  Год назад

      Thanks for the question. CTRL+F will help you to get to replace dialog box.

    • @Stephanie-b2m1d
      @Stephanie-b2m1d Год назад

      Yes, but I want to add it to a macro, if possible@@MyExcelOnline

    • @MyExcelOnline
      @MyExcelOnline  10 месяцев назад

      Are you asking if CTRL+F can be used to run a macro? No because it is already reserved. You may be able to use CTRL+SHIFT+F.

  • @dainguyen-vm8ys
    @dainguyen-vm8ys 2 года назад

    Hello, when I uploaded the excel file to OneDrive, the developer tab disappeared, and I could not enable developer tab for the excel file stored in OneDrive. Please help!

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi. I would suggest opening Excel and right clicking on the ribbon and choosing Customize the Ribbon.... On the right side of the screen you should be able to check the Developer ribbon again. Please let us know if you have anymore questions!

  • @murthalashafiul3648
    @murthalashafiul3648 5 лет назад

    so nice

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Glad you liked this Excel Macros & VBA tutorial!

  • @sajedezare5219
    @sajedezare5219 3 года назад

    Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Please check our blog and if you don't find the answer, feel free to contact us there. www.myexcelonline.com/blog/

  • @Mayur20408
    @Mayur20408 2 года назад

    I want to create new macro to replace given path to other tab as input given through macro

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Please check out our blog for more info: www.myexcelonline.com/blog/

  • @zeerakkhan6980
    @zeerakkhan6980 5 лет назад

    Sir need your help about conditional formatting!
    I want to highlight the row whenever I type "QC" in that row, and not all the cells in that row, want to highlight only those cells in that row which are filled (not empty).
    please guide!

    • @MyExcelOnline
      @MyExcelOnline  5 лет назад

      Please look at this tutorial which will help you out: www.myexcelonline.com/blog/conditional-format-a-cells-value/

  • @grammybts7664
    @grammybts7664 2 года назад

    Hello sir,
    The file is not downloading... I tried multiple times...

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Hi. You can clock this link and hit the Download Now button and put in your email and we will email it to you.
      myexcelonline.lpages.co/youtube-formulas-webinar-workbook-downloads/

  • @vikassuryawanshi9760
    @vikassuryawanshi9760 2 года назад

    i have a excel file having 21 sheets using micros. need to add more sheets

    • @MyExcelOnline
      @MyExcelOnline  2 года назад

      Here is what Microsoft says about adding worksheets: "Limits on Sheets in a workbook are Limited by available memory (default is 1 sheet)". Are you having trouble adding more sheets to your workbook?

  • @angiemowat5077
    @angiemowat5077 4 года назад

    when you are creating a macro to copy and paste value into another sheet, can you copy down or do you have to only go right to left?

    • @MyExcelOnline
      @MyExcelOnline  4 года назад

      You can copy whichever direction you like

  • @AndreaFriedli
    @AndreaFriedli 6 месяцев назад

    I followed the VBA for adding sheets inside of sheets and kept getting a bug error.

    • @MyExcelOnline
      @MyExcelOnline  6 месяцев назад

      Hi. Thanks for watching! I would recommend downloading the sample workbook and comparing it to what you have written, as VBA needs to be exact. Or you can go back over the video and double check every line to see that it matches yours. The link to download it is in the description. Hope that helps!

  • @qamruddinmohammedi7665
    @qamruddinmohammedi7665 3 года назад

    Dear Sir,
    Want transfer data from one workbook to another.
    Workbook - A
    1. Receipt No.
    2. Date
    3. Name
    4. Amount
    To Workbook - B in two different Sheets
    can you please help to write correct VBA code.

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hi. You could select everything in one sheet by clicking the square between the Column A and the Row 1. That will select the whole sheet. Then you can copy everything that is selected in Worksheet A and paste it into the new sheets. Does that answer your question?

    • @qamruddinmohammedi7665
      @qamruddinmohammedi7665 3 года назад

      @@MyExcelOnline Thanks for your reply, but I want to transfer some to particular items only to the another workbook

  • @NixelPresentation
    @NixelPresentation 3 года назад

    Sir
    Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Please check out our Blog here for the answer: www.myexcelonline.com/blog/

  • @prasenjitmandal5486
    @prasenjitmandal5486 3 года назад

    Hi need your help,
    Can we use VBA code in shared mail box

    • @MyExcelOnline
      @MyExcelOnline  3 года назад

      Hi Prasenjit. Do you mean in Microsoft Outlook? If so, yes, VBA can be used there as well as in most Office products (Access, Word, Excel).