Learn How To Create Tabs in Microsoft Excel In This Easy VBA Tutorial Video

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

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

  • @ExcelForFreelancers
    @ExcelForFreelancers  4 месяца назад

    🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

  • @francesoutlaw7021
    @francesoutlaw7021 Год назад +1

    This is so beautiful!!! I also appreciate the fact that your English and accent are so understandable compared to others I cannot make out what they are trying to saying. Hu hu hu! I'm so happy I'm crying. Quick question: Why do you have to type "C" before "True"? And what does "C" mean?

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

      Hi Frances, thanks so much. I really appreciate that. I have lived outside the US for 18 years, so I think it has been important for me to speak English without slang in order for people to understand me. The 'C' in MSOC stands for Component in the Microsoft Office Component library.
      I hope this helps and thanks so much.

  • @Akulion1
    @Akulion1 4 месяца назад +1

    Thank you so much this came in really handy for something I've been creating. A cool unique way to switch between forms!

  • @a.salim123
    @a.salim123 4 года назад +1

    Tank you so much. I enjoyed your video and created my own using.

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

      Hi Salim,
      Thanks so much. I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.

  • @atouchofa.d.d.5852
    @atouchofa.d.d.5852 5 лет назад +1

    I was a little shocked how much you speak about color choices, but I realize how professional these choices make your sheet.

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

      Thanks so much. Yes i think the look and feel is an important part of professional applications. I really appreciate your comment.

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

    What an excellent tutorial. I had great fun replicating it on my Mac with just two, rather than three tables. I didn't bother doing three, because I understand what you are doing.

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

      Hi Bev, thanks so much for the comment and very well done. I have many other videos in which I think you will also enjoy. My last 8 videos I also create from scratch so I think you will enjoy that as well.

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

    Excellent. Superb. Simple and very creative idea. You make Excel like a kid's toys.

  • @nacrimal
    @nacrimal 3 месяца назад +1

    This is amazing and simple. You're great

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 месяца назад

      Thank you so very much, I really appreciate that and I am happy to help and share

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

    Thank you very much for the video. Everything works and it's cool.
    Please tell me, how to make 10-20 copies of the Sheet with all settings saved?

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

      HI and thanks. You can use the 'Save As' feature and just save it as a different name. I hope this helps and thanks so much.

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

    Wonderful video sir.. I have practiced on it. And the trick helping me to get my dashboard dynamic look.
    Thanks again.

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

    Very nice tutorial.for the very first time i am able to understand the VBA...

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

    I love you, literally you are number and your all formats are number 1 in the world

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

      Thank you so very much, I really appreciate that Sanntosh

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

      @@ExcelForFreelancers can you please talk to me on WhatsApp
      +918180011931 is my WhatsApp number
      Please sir

  • @kalpanathakur6300
    @kalpanathakur6300 6 месяцев назад +1

    Thank you so much I am looking for how to make tabs in excel from many day
    Thank you once again sir ❤.

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

      For sure, you are very welcome and I am happy to help and share

  • @messaoudpolitique9208
    @messaoudpolitique9208 Год назад +1

    Always top application thank you Mrs Excel

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

    This was absolutely fabulous! Took awhile to get it going but once I did, it started coming together nicely. Only problem I have is now when I click on a tab, it pulls up the screen outside of where it should and I have to "pull it in" so to speak like you did in this video,(you had to slide it back over) but you had to only do it once, so I'm not sure what I'm doing wrong. But otherwise, it all worked. Thank you for such a detailed video

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

      Hi Stephanie thanks very much. I am really glad you liked the training. You can automate the scroll, horizontally or vertically. So you may want to add a last line of code to pull the screen back to the column (or row) that you want. Something like this:
      Activewindow.Scrollrow=1
      or
      Activewindow.Scrollcolumn = 1
      Just change 1 to whatever column or row you want

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

      @@ExcelForFreelancers Thank you! It worked like a charm. I appreciate it!!!

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

      Thank you had the same issue and worked perfectly, really good tutorial cheers @@ExcelForFreelancers

  • @asharzia1262
    @asharzia1262 Год назад +1

    Honestly this video helped me alot .Thank you. it is very informative.

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

    This is Mind blowing !!! Many Many thanks for this Randy !!! All my reports now have been superseded by this way of visualization !! i was exactly looking for this !!! Regards from India ...................

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

      That is so great to hear. I am so glad you like it. Not to add more features, but if you liked this tab video check out this cell-based tab video (its even simpler, but maybe not as beautiful) ruclips.net/video/iyr9WIyxlJc/видео.html

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

    You are excel god love from India

  • @asharzia1262
    @asharzia1262 Год назад +1

    I did 12 buttons and it all really worked❤️❤️

    • @ExcelForFreelancers
      @ExcelForFreelancers  Год назад +1

      Wow great. Good job and thank you for your Likes, Shares & Comments. It really helps.

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

    Very nicely done! I wish my job had a use for this. I have to create and print documents.

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

      Hi thanks so much I am glad you liked this. You may also like the Step By Step Wizard which includes a summary in which you can print here: ruclips.net/video/-AfBDqdwU8k/видео.html

  • @anirudhm7058
    @anirudhm7058 Год назад +1

    This is just fabulous sir, Thanks a Lot

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

    Bless you bro!! Just perfect!!!

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

    Great tutorial. Thank you for this. I will be using this to improve my work going forward

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

      For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

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

    @19:07 - Off screen editing (You little cheat you...)
    Nice idea and nice presentation, I got the 150 book and enjoying it so far.
    K

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

      Thanks so much. I am glad you liked the training (and caught the edit). I hope you enjoy the 150 workbook pack and thanks so much for your purchase.

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

    Thanks a lot Randy Sir....

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

    Thanks for sharing such useful files !!!

  • @MrKunal995
    @MrKunal995 4 года назад +4

    Thank You SO much Randy for this lovely tutorial! I worked on this with some little changes and it went on just so seamlessly well with your incessant guidance. But I would like to know after making these tabs, how will I keep a track of Gen Info, Time and earning History for many employees. If I choose an employee name from Gen Info tab, the rest of the tabs could show all Time Clock and Earning related to that specific employee. Hope you get what I am saying. Would love to see your take on this. Thanks in advance mate!!!

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

      Hi Kunalj, you can just use a drop down list of an employee above all the tabs. When a new employee is selected, all of their information is then filled it. I teach all of this in my Employee Manager Series on my channel here: ruclips.net/user/ExcelForFreelancers
      Thank you for your Likes, Shares & Comments. It really helps.

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

    You're a life saver!!! Thank you!!

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

    excellent tutorial sir

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

    Thanks for the tutorial!

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

    Muy buen vídeo. Gracias por compartir. Cada día Se aprende más.

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

    Thanks for sharing this man....Been looking for a way out with my CMDB on Excel

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

    Thanks for the tutorial. Just finished my work using this cool idea. 😎👍

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

    Thanks. Just what I'm looking for.

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

      Great, happy to help. (Also please check out this video where I do both Horizontal and Vertical cell-based tabs: ruclips.net/video/iyr9WIyxlJc/видео.html

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

    Thanks i have learn something new here.....TQSM

  • @joemanflyer2001
    @joemanflyer2001 2 месяца назад +1

    This is very convenient!

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

    Thank you for a great tutorial. This is an excellent way to present data in a compact form.

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

      Thanks so much Mark I am really glad you like it. I have other videos with cell-based tabs that is really cool as well (as opposed to shape-based tabs)

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

    Nice lesson. Very useful. Thanks a lot.

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

    thanks alot

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

    Thank you. You should include "VBA" in the title, more people would visit your videos. You explain the VBA code very well, line by line. Great!!

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

      Excellent Idea. Thanks, I just made the change to the title :)

  • @instantt
    @instantt 6 лет назад +2

    Yeah !!! so good, and the tip about screen flashing, great !! Thx

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

    Thanks a lot... such a nice tutorial....Great Job Bro..

  • @AbhishekKumar-eb9hb
    @AbhishekKumar-eb9hb 4 года назад +1

    Amazing work sir....

  • @ToanNguyen-lb8fv
    @ToanNguyen-lb8fv 5 лет назад +1

    Very helpful. Thank for your video!

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

    Thank you, for videounit

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

    Simple yet effective. Thank you 🙏

  • @RubinGnoni
    @RubinGnoni 6 лет назад +2

    I loved it and it will work great for me. What happens with the view when, for example, the Time Clock History increases in size to 20 lines and more? Thank you.

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 лет назад +4

      Hi thanks for your comment. There should be no issue since its only the columns that are hidden/shows. Rows are always displayed so there should be no issue at all with additional 20 or even 2000 lines, You may want to freeze the header so that the tabs are always displayed when you have a lot of rows.

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

    In this video you explained about how to manage the tabs. However for understanding how you made the first filling form for general employee info input, I appreciate if you could lead me to a tutorial about how can I make that form. Much appreciated in Advance.m

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

      Hi thanks very much for your comment. In the following video I show you how to Automate Tabs, Save & Load which should be helpful:
      ruclips.net/video/40aYorpxPiU/видео.html
      I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel

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

    Thanks great tutorial. I appreciate your efforts and generosity. really I was looking for type of tuite. please create opening user from as well

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

      Hi Mohamad, Thanks very much. I am glad you like the videos. I do have a user form on opening here: ruclips.net/video/0ahYoy5L3ec/видео.html

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

    you think the video is long? well i am going to watch over again. very insightful. thank you

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

      Thanks most of my videos are long these days. (Especially the current Employee Manager series, which are around 1 hour per video) I just get so excited to tech lots of new and cool tricks. Thanks so much for your comment.

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

    Excellent video. Thanks for sharing.

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

    This is super awesome.

  • @sunny-uw9mw
    @sunny-uw9mw Год назад +1

    Please make one video on hospital management & pharmacy management in excel

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

      HI and thanks so much. A hospital management application would be a massive software however I to have one on a Clinic Manager here: ruclips.net/video/9oebyN-ivhU/видео.html
      I would consider a Pharmacy Manager in the future although i would have to understand more about the software.
      Thank you for your Likes, Shares & Comments. It really helps.

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

    Excellent video, thank you very... very much!!!!!!

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

    Randy!! TYSM for an amazing tutorial! Question though ... what if I want to print my workbook to present in paper form at meetings and such? (Yes, I work with folk that still like paper!). Am I correct in assuming I'm going to have to keep another bland copy on hand cause this beauty won't print in all its glory?

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

      Hi and thanks Bindi. You can print anything and everything you want, however it may take some VBA code to do that, (since you might have to switch tabs in the Print macro)
      If you need help with this, I would be happy to refer you to a qualified developer. Randy@ExcelForFreelancers.com
      Thank you for your Likes, Shares & Comments. It really helps.

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

    Great idea. Also, thanks for the HotKey tip. Works beautifully.

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

    Just too good. Enjoyed watching this.

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

    Awesome video Randy ! Keep the great work !

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

    Great explanation 👍👍. Thank you very much.

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

    Many Thanks, it was very useful and great help please keep up with these great videos

  • @mindy.kchyt_3225
    @mindy.kchyt_3225 6 лет назад +1

    Thank you! This video was very helpful in helping me write my first Macro!

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

      Hi, you are very welcome. I am glad you liked this horizontal tabs tutorial. Feel fee to try out the Vertical Tabs Tutorial which is even easier here: ruclips.net/video/RkLD1AtF1Cw/видео.html

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

    Excelente, es usted un maestro, gracias por el vídeo

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

    Thank you, sir, your way of teaching is awesome and appreciable

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

    Great work
    Thank you very much

  • @Bigns-bi
    @Bigns-bi 6 лет назад +2

    Hi! Great video. Is it possible to make it with many sheet from different workbook.
    Also I'm triying to seach and copying data from other workbook. Is it possible you help?

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

      Hi thanks this is very possible and in fact my video being released tomorrow (6/12/2018) will show you how to connect data from another workbook, so I believe you will find it very helpful.
      I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel

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

    Thank for sharing the information.

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

    Thanks brother, God Bless You 😀

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

    It's a great work thanks alot for sharing your knowledge
    How can I learn basics of coding VBA

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

      Hi Mohamed, thanks so much. I am glad you like it. Here is a great course on VBA Basics by Leila Gharani: bit.ly/VBA_BeginnersCourse

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

    VERY NICE VIDEO SIR

  • @user-ud7fy7mg4y
    @user-ud7fy7mg4y 6 лет назад +1

    thanks for letting us see

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

    Hey Randy.Thank you so much for this wonderful video.!Could you please lend me a hand. I got everything in my tab like this working perfectly. Just dont know how can I force the file to stay on the interface. Just like what happened with you at 22:13 that you need to scroll a little just to go to the interface again.I've tried application go to range scroll true but no success. Thanks in advance!🙂🙂🙂

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

      HI Carmela, Thanks very much for your comment and question. I am glad you like the video. You can use ActiveWindow.ScrollColumn = 4 to get the application to automatically scroll to a specific column. 4 would be column D. I hope this helps.

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

    Hi Randy,
    Thanks again very good presentation and very interesting way to present informations.
    I tried to use it and I have a problem. I have Excel 2019 and even if I change the properties to Do not move or Resize, my shapes are still moving when I scroll my sheet either up or down or left or right.
    I would have love to test your workbook, but I cannot download it. Do you know if there is a problem with Excel 2019…??
    Thank you.

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

      Hi Guy, thanks so much. the shape should not be moving however if you do not have enough visible area, meaning too many columns or rows are hidden, then it could still move. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

  • @luisgonzalez-pj2ib
    @luisgonzalez-pj2ib 6 лет назад +1

    wow Thank you so much for all your time and effort.

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

    Nice video advice

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

    A very well explained video. Thank you Randy.
    Randy: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. Your help is greatly appreciated.

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

      Yes, actually I have a course coming out in a month or two which shows exactly how to create drop down lists in Excel. Here is a quick 2 minute sample (no sound): bit.ly/DashSampleVid

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

      Thank you for your reply. I am looking for more like a menu not drop down list.

  • @Rana-qn8xc
    @Rana-qn8xc 5 лет назад +1

    So Great .............! Thanks for sharing Your Knowledge

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

    Hi Randy. Awesome technique! Will study this further. Thanks for sharing it :)) Thumbs up!!

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

      For sure, you are very welcome Wayne I am glad you liked this training.

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

      @@ExcelForFreelancers Thanks! Already learned a lot following the tutorial and building along with you. I even came up with some of my own ideas for the interface and code. Thanks for the inspiration to learn and create :)) Thumbs up!!

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

      For sure, you are very welcome Wayne, Happy to help

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

    Nice work...Very Helpful...Thank you

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

      Of course, you are very welcome. Happy to help.

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

      Hi I think its definitely possible when you pull data from a database. I have created a Facebook group with 5000+ Excel Exerts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.

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

      Excel For Freelancers thank you for quick response and FB link. I have joined and will explore

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

    Thank you, i like your chanel

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

    Nice sir thanks

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

    Nice work Randy. Top drawer yet again.

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

      Thank you so very much, I really appreciate that Phil.

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

      @@ExcelForFreelancers Does your course include the learning of VBA for beginners?

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

      Hi Phil, it has just a bit, but not much, however I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

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

    Great sir

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

    great job and video, thanks for sharing this info

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

    SUPER !

  • @nguyenTran-ju7lp
    @nguyenTran-ju7lp 3 года назад +1

    Very amazing

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

    Wow its great.....

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

    That was well cool I'm sure I will use it soon

  • @ms.vynetesorero1946
    @ms.vynetesorero1946 5 лет назад +1

    The best tutorial so far. Thank you.

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

      Thanks so much Gurong, I am so glad you like it. Here is another way to do tabs that you might like: ruclips.net/video/iyr9WIyxlJc/видео.html

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

    sir thanks a lot off may you live long May GOD shower his blessings upon you.

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

    you are a MASTER!

  • @avyannalou7533
    @avyannalou7533 6 лет назад +2

    great video,excellent tutorial...please make more tutorial about survey formula, satisfactory, like disagree,agree,strongly disagree,strongly agree.

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

      Hi thanks I like your idea and I will create a training video on that in the near future.

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

    Brilliant tutorial as always. I have a doubt, say the tables are present in Sheet 1 and the display with tabs is present on sheet 2, what changes will have to be made to create this model?

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

      Hi and thanks you will just have to update the code to specify a sheet # when saving and loading data. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

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

    Excelente video, gracias por compartir su conocimiento.

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

    Hello sir, The all videos are best...

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

    Thank you very useful

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

    Learn some new things thank you.

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

    Thank you

  • @MasudRana-qc5xy
    @MasudRana-qc5xy 6 лет назад +1

    awesome video

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

    thanks buddy!! learned a lot

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

    wooow pretty cool
    very nice subject