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

[@ExcelForFreelancers]

🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm

[@atouchofa.d.d.5852]

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

[@ExcelForFreelancers]

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

[@francesoutlaw7021]

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]

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.

[@MrKunal995]

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]

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: kzbin.info Thank you for your Likes, Shares & Comments. It really helps.

[@bevintx5440]

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]

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]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@mariakorotkova6933]

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]

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.

[@mayboli7438]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Sanntosh

[@mayboli7438]

@@ExcelForFreelancers can you please talk to me on WhatsApp [phone] is my WhatsApp number Please sir

[@VickyT2843]

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

[@ExcelForFreelancers]

For sure you are very welcome. I am happy I can help.

[@Akulion1]

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

[@ExcelForFreelancers]

Great, thanks so much and I am happy to help and share

[@stephaniegallentine]

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]

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]

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

[@arthurbirnie7924]

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

[@guychoquette4872]

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]

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

[@bindistokes4414]

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]

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. [e-mail] Thank you for your Likes, Shares & Comments. It really helps.

[@chethankodandarama1204]

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]

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) kzbin.info/www/bejne/n6rVaop_rt2fgMU

[@Bigns-bi]

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]

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

[@MohamedEzzeldin-y3h]

Hi Andy, Thanks for this great video! I have created my own report followed your instructions in the video and it is working good except a small issue when i apply "TabGen" Macro, it really hide/unhide the targeted columns but the Screen automatically - by default - shows the columns start from "W,X,Y....->" column so i have to go with row to left (the page beginning) and this make hassle with me. How we can we solve that :)

[@ExcelForFreelancers]

HI Mohamed, thanks for your feedback. I am really glad you like the training. You can automatically scroll to any row or column in VBA with lines of code like this: ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 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

[@MohamedEzzeldin-y3h]

Wow! it's fixed and working smoothly now :) regarding the group, i am already there. Good job and wish you all the best. Thank you!

[@main-wayout]

That's pretty for sure. is there anyway to bring the data from sheet 2 or 3 (different sheet I mean) or they have to be in the same sheet that includes the tabs? Thanks in advance

[@ExcelForFreelancers]

Hi there are many ways to bring the data from other sheets. If it is a filtered data you can use an advanced filter, straight cell links or a value to value copy. I hope this helps and thanks.

[@main-wayout]

@@ExcelForFreelancers Thank you for the amazing video and for this clarification. What am trying to tell you is that when I press on the tab Gen Info for instance, I want to bring the relevant data from another sheet and show it in the same sheet where the tabs are located. it seems to me that we need to edit the code itself to be for instance "with sheet2" instead of sheet1. I tried it but didn't work out. Thanks anyway, it is still very nice and useful video.

[@ExcelForFreelancers]

Please see my Employee Manager series here on KZbin for samples on how to do that.

[@warawarahlatshwayo3441]

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

[@ExcelForFreelancers]

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

[@RubinGnoni]

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]

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.

[@chiwilanjabulosikwila3487]

For the shapes, is there a specific reason you use msoCTrue as opposed to msoTrue in the macros?

[@ExcelForFreelancers]

Hi and thanks I use 'True' when checking to see if a shape is visible and msoctrue, which is the natural code for shapes, within Excel. This is just the basic rules as designed as far as i know. I hope this helps and thanks so much.

[@fahadgilani630]

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

[@ExcelForFreelancers]

Thanks very much. I am really glad you liked it.

[@HeyTCT]

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]

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

[@keshavroyyala]

Excellent video Randy. Is there any way we can hide specific set cells instead of entire columns?

[@ExcelForFreelancers]

You can how rows, columns of course or you can hide specific contents of cells using a custom cell format of ;;; (3 semicolons) I hope this helps and thanks so much.

[@carmelaroxas8446]

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]

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.

[@asharzia1262]

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

[@ExcelForFreelancers]

That is really great to hear. I am happy to help and share

[@philsky_in_oz]

Nice work Randy. Top drawer yet again.

[@ExcelForFreelancers]

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

[@philsky_in_oz]

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

[@ExcelForFreelancers]

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/

[@saurabhm19782]

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]

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]

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

[@oussamaziani9405]

Hi mate what if I wanted to create a multiple taps section one below another I mean when I’m doing this for the first horizontal tab it’s ok but when I’m creating the next one it’s get so messy thanks for helping out :)

[@ExcelForFreelancers]

Hi thanks so much for your comment. You will want to make sure to plan this all out in advance since its harder to change once you have added the code. I have other ideas for tabs you may like right here: kzbin.info/www/bejne/n6rVaop_rt2fgMU 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

[@kalpanathakur6300]

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

[@ExcelForFreelancers]

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

[@NickGeorgaras]

Great job! I have one simple question. If i put inside the main frame (one just like yours) an image (*.png) as my logo, every time i click on a button (in my case), the image is flickering at every push. Is there a way not to flickering?

[@ExcelForFreelancers]

Hi thanks for your comment. Yes you can get it to stop flickering. At the beginning of the macro add Application.ScreenUpdating = False then before the macro ends add Application.ScreenUpdating = True That should fix the problem. 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

[@SalAbraham7]

Is there a way to make horizontal tabs within using formulas in the cells to navigate between different sheets intead of using shapes and macros?

[@ExcelForFreelancers]

Yes sure you can use Hyperlinks in any cell to navigate to other sheets, so that is not a problem. If the rows, columns and designs are exact between different sheets it could have the 'Tab Effect' Give it a try I think it would be nice.

[@SalAbraham7]

@@ExcelForFreelancers The Thank you, Sir But the problem is that once you rename the sheets the hyperlink doesn't work..

[@ExcelForFreelancers]

If you rename sheets often then its best to use VBA, using Sheet1, Sheet2, etc, then it does not matter if sheets are renamed, the code will always work.

[@SalAbraham7]

@@ExcelForFreelancers thank you sir, fortunately I got solution for creating horizontal or vertical tabs by using formulas either with cells or shapes to navigate between sheets and it could perfectly works while remaining the sheets

[@ExcelForFreelancers]

Ok thats great. Navigating between sheets does not require as much, and works great with formulas & hyperlinks.. however this video focuses on Hiding & Showing columns on the same sheet. Your comments are much appreciated.

[@barttitulaerexcelbart9400]

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]

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

[@a.salim123]

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

[@ExcelForFreelancers]

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

[@jerometurmel4208]

Awesome video Randy ! Keep the great work !

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Jerome

[@HKrawick]

Can you search by name on the general form so the tabs display per employee?

[@ExcelForFreelancers]

Hi and thanks yes you can, Please check out my Employee Manager series for this here: kzbin.info/www/bejne/n6rVaop_rt2fgMU&ab_channel=ExcelForFreelancers I hope this helps and thanks so much.

[@kittydoes7600]

Wow this is amazing. What if instead of columns, I want to switch to different sheets instead? What would be the code?

[@ExcelForFreelancers]

HI thanks so much for your comment. You can use different sheets as well, just use the Activate method in your macro such as 'Sheet1.Activate' or 'Sheets("Customers").Activate Also you will want to make sure that each sheet has the same exact tab buttons in the same location so make sure you select the "Don't Move or Size" option for these buttons in the Properties.

[@kittydoes7600]

Excel For Freelancers thank you for the prompt reply. 😊 I'll try that. Thank you so much for the help!

[@ibrahimnazemqader9153]

Kather- pillar ون

[@casendriepillay3861]

Hi, thank you for sharing this very informative video. I am new to VBA, however I have followed all your guidelines but when I click on run, The Sub TabGen header gets highlighted in yellow with a message "variable not defined" please may you assist me with this. Thanking you in advance.

[@ExcelForFreelancers]

Hi Casendrie thanks so much for your comment. You will want to define each variable, however we would need to see your code. Can you please upload a picture of your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much. Also there is a free VBA training, taught by another Excel MVP, on my website in which you can enroll here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ Thank you for your Likes, Shares & Comments. It really helps.

[@christmaswithcurtis2018]

I enjoyed your video and created my own using your tutorial. I am trying to lock the cells so users can’t edit the information on each tab. Is there a way to lock particular cells and still allow macros to run. VBA keep getting error at the entire column hide code. I assume it’s because the cells are lock so you can’t hide. Is there anyway around this?

[@ExcelForFreelancers]

Hi yes there are a few ways. You can allow the user to format columns and rows in the protection checklist, or you can add Unprotect VBA code when the macro begins and Protect the sheet before the macro ends, such as : Sub Test() Sheet1.Unprotect "Password" 'Your code here Sheet1.Protect "Password" End Sub 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

[@nahummadrid4512]

Great Video. I have a question: if I hide, say columns from L onwards, my tabs shrink and yet, I have stated don’t move or size with cells. Is this a problem caused by hiding columns?

[@ExcelForFreelancers]

Hi if you set to move and don't size the tabs should not move or size when you hide cells depending upon the location. You should try move but dont size. 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

[@iamjunivel]

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

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@asharzia1262]

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

[@ExcelForFreelancers]

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

[@shadowx2k2007]

Hi, Great video. Signed up to receive the spreadsheet in the tutorial but nothing has come through. Is this spreadsheet still available?

[@ExcelForFreelancers]

Hi, Yes it is. (I am changing email companies so this problem does not happen in the future) You can download this file from the following link: bit.ly/Horiz_Tabs

[@shadowx2k2007]

@@ExcelForFreelancers Thanks.

[@kentaczdys]

Hi Randy, thanks for amazing tutorial. I've done it for 12 tabs (months), but I have a problem. When I'm changing the tabs one by one forward and backwards is ok but when I want to switch by 2 tabs backwards for example from March to January focus on the screen is outside the tables on empty space from cell FA to GA , last cell with the table is EZ. Could you please help on this one. I'm not sure what went wrong. Thank you.

[@ExcelForFreelancers]

Hi Kent, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@kentaczdys]

@@ExcelForFreelancers Hi Randy, I don't have Facebook account please let me know if there is any other way?

[@ExcelForFreelancers]

Hi Kent, yes for sure. If you email me ([e-mail] ) I can refer a developer to help you with this. I hope this helps and thanks so much.

[@md.mahmudulhasan4497]

Amazing video. I have done this with 26 buttons. And all are working just fine. highly appreciated and thanks. I have just one query. Let me elaborate first. in this video, you have put the content into tabs from the same sheet, i mean the whole content was in a sheet. what if i want to put all my content into this tabwise format where these contents gotta be coming from different sheets? How do i write the code for that? I reckon this videos has been 5 years old, so if there is a chance that you might have already uploaded something that answers my query, would you please share the link? or help me anyway?

[@ExcelForFreelancers]

HI and thanks so much. I did create a video in which I had a tab system that actually hid columns to display contents all on the same sheet and the data was pulled from different sheets here: kzbin.info/www/bejne/a3PaaIeQZa59itE I hope this helps and thanks so much.

[@md.mahmudulhasan4497]

@@ExcelForFreelancers i have another question if you dont mind. What if try this same procedure for verical tabs where i only have to place the shapes vertically instead of horizontally and keep the other things same as this video? Will that work?

[@ExcelForFreelancers]

Yes for sure it will work. I have several videos on that, just search my channel for 'Vertical' I hope this helps and thanks so much.

[@YerNabob]

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

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/Y3LJc3enmdyIbs0

[@MrAitch_]

@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]

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.

[@dattathreyasanjeev9532]

Simple yet effective. Thank you 🙏

[@ExcelForFreelancers]

You are very welcome, happy to help.

[@wayneseymour1]

do you have a video for how you create the hotkey automation or the software that does it?

[@ExcelForFreelancers]

Hi Wayne, Thanks very much for your comment. I do not have any hotkey automation.

[@wayneseymour1]

13:47 this part of your tutorial when you type the "With" then the "End With" is added automatically isnt that done with autohotkey?how can I get the code for that?

[@ExcelForFreelancers]

Ahhhhhh. Now i understand. Auto-Hotkey is the program I use, but the code must be added to Auto-hotkey script like this: #IfWinActive ahk_class wndclass_desked_gsk :b0:with::{Enter}{Enter}{Enter}End With{Enter}{up 2}{end} :*:then`n::Then{Enter}{Enter}End If{Enter}{up 2}`t :b0:select case::{Enter}{Enter}{Enter}End Select{Enter}{up 2}{end} :b0:do::{Enter}Loop{Enter}{up 2}{end} ::diml::Dim As Long{Left 9} ::dims::Dim As String{Left 11} ::dimr::Dim As Range{Left 10} ::dimd::Dim As Double{Left 11} ::lr=::LastRow = Range("A1").End(xlUp).Row ::Vbc:: & VbCrLf & " ::.r::.Range("").value{Left 8} ::ifn::If Not Intersect(Target, Range("H12")) Is Nothing ::apw::application.WorksheetFunction.Match(" These are just some, you can add your own as much as you want.

[@MrCraptakular]

Wouldn't tasks like this be better serverd using something like a python environment as you can build a web browser version with phython alonside the data manipulation? Just curious, at what point do you decide Excel simply isn't the best tool?

[@ExcelForFreelancers]

HI and thanks, while there are great tools to build software, we use Excel, because Excel is the tool that people have and are comfortable with. Instead of bringing customers and users to our software, we are taking our software to them by using Excel, so the path is shorter. Excel is also extremely flexible. So the 'best platform' also means what is the best for our end users. I hope this helps and thanks so much.

[@thehero9583]

Hi, thank for the detailed explanation. I would like to do the same but with little change I have earnings data in sheet 2 and time in sheet 3. How can I handle this scenario.

[@ExcelForFreelancers]

Thank you for your message. you can combine the data into a single sheet, so that the tabs feature works seamlessly . The application is open and your are welcome to customize this to fit your exact requirements. If you would like some help with this, we have a group with 12,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.

[@pawanchaudhari8566]

Thanks A Lot Randy !!!!! This Is Great 👍 This tutorial help us lot. I have created the same macros for 22 tabs, almost everything is fine though I am experiencing bit glitch while jumping from last tab to first tab. Display shows unknown range of cells ( Similar as in this video @ 22:12, when you click on first tab its slide away ). Is there any solution to get rid of this issue. Many Thanks. :)

[@ExcelForFreelancers]

Hi thanks very much for your comment and liking the video. There could be a few reasons for this issue. Perhaps you can join our Excel For Freelancers Facebook Group here; bit.ly/groupexcel , then upload your screenshot and code so we can help you with the problem. Thanks so much.

[@pawanchaudhari8566]

Excel For Freelancers Sure, will do. 👍

[@Gaurav.singhchauhan]

Thank you so much sir, One question...... how can we do this in protected excel sheet

[@ExcelForFreelancers]

Hi thanks you can just unlock the cells in which the user or VBA will change and then protect the sheet. Give it a try and if you run into any issues please feel free to post your bug in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.

[@casper3842]

Great tutorial. But how can we use scroll bars on each tab results?

[@ExcelForFreelancers]

I there, you should be able to use scroll bars as long as the columns are hidden that you do not want displayed. Vertical scroll bars would not have any effect and you could freeze the top set of rows to keep the tabs visible. 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

[@casper3842]

Thanks for your time to answer. But i mean is, the scroll bars which can be used in the result sheet to show.

[@ExcelForFreelancers]

Hi i am not sure what you mean. Can you please upload a screenshot in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel So that I and the other members can have a look and make suggestions. Thanks very much

[@markreichard2144]

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

[@ExcelForFreelancers]

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)

[@AlvaroGarciaMS]

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

[@ExcelForFreelancers]

Graicias Mi amigo Alvaro

[@nacrimal]

This is amazing and simple. You're great

[@ExcelForFreelancers]

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

[@octycool]

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

[@ExcelForFreelancers]

For sure no problem, happy to help

[@safetyatoz9878]

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]

Hi thanks very much for your comment. In the following video I show you how to Automate Tabs, Save & Load which should be helpful: kzbin.info/www/bejne/amHEiqKopd2Dn7c 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

[@wayneedmondson1065]

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

[@ExcelForFreelancers]

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

[@wayneedmondson1065]

@@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]

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

[@mohamadsiddeek7912]

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]

Hi Mohamad, Thanks very much. I am glad you like the videos. I do have a user form on opening here: kzbin.info/www/bejne/ZpLLiqKvarFmm8U

[@boyelliot1052]

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

[@ExcelForFreelancers]

For sure, you are very welcome I am glad I could help

[@mohamedzeed2129]

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

[@ExcelForFreelancers]

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

[@argiris2011]

Bless you bro!! Just perfect!!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@krn14242]

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

[@ExcelForFreelancers]

For sure, I am happy to hear that. Glad to help you :)

[@VT_777]

Nice lesson. Very useful. Thanks a lot.

[@ExcelForFreelancers]

Thanks so much. I am glad you like it.

[@ibsh7236]

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

[@ExcelForFreelancers]

Thanks so much, I am really glad you like them.

[@ToanNguyen-lb8fv]

Very helpful. Thank for your video!

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@jenniferharvey6322]

This was extremely helpful, but I have an additional question. I have a dropdown header that I need to stay on the sheet across all tabs so I can't choose the entire column. How do I type out to only include certain cells to show instead of entire columns?

[@ExcelForFreelancers]

Hi another way to do this is to hide/show rows, not columns. I demostrante this in a cell-based tab in this video: kzbin.info/www/bejne/n6rVaop_rt2fgMU

[@jenniferharvey6322]

thank you!

[@Tommietusindbuks]

Great video, what kind of automated software are you using, that can complete you with the statement?

[@ExcelForFreelancers]

Hi i am using the free AutoHotkey. After downloading it just create an .ahk file and add the following: #IfWinActive ahk_class wndclass_desked_gsk :b0:with::{Enter}{Enter}{Enter}End With{Enter}{up 2}{end} :*:then`n::Then{Enter}{Enter}End If{Enter}{up 2}`t :b0:select case::{Enter}{Enter}{Enter}End Select{Enter}{up 2}{end} :b0:do::{Enter}Loop{Enter}{up 2}{end}

[@Tommietusindbuks]

Nice thanks!

[@messaoudpolitique9208]

Always top application thank you Mrs Excel

[@ExcelForFreelancers]

For sure, you are very welcome Messaoud

[@azharhusin6540]

Great explanation 👍👍. Thank you very much.

[@ExcelForFreelancers]

For sure, you are very welcome.

[@awesh1986]

Just too good. Enjoyed watching this.

[@ExcelForFreelancers]

Thanks so much Awesh, much appreciated.

[@instantt]

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

[@ExcelForFreelancers]

For sure, you are very welcome

[@anirudhm7058]

This is just fabulous sir, Thanks a Lot

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Anirudh

[@Berghiker]

Thanks. Just what I'm looking for.

[@ExcelForFreelancers]

Great, happy to help. (Also please check out this video where I do both Horizontal and Vertical cell-based tabs: kzbin.info/www/bejne/n6rVaop_rt2fgMU

[@popsmikehull]

Thank you, I really enjoyed this video but could you do another one to explain in more detail how the formula works in the tab naming cells please, when I got the file there appeared to be an error so I had yo create a new and delete the previous one because it had 2 sheet 2's listed. Thanks Mike

[@ExcelForFreelancers]

Hi here is another one, that is similar with vertical tabs: kzbin.info/www/bejne/iJyvdWR3qatkedk

[@popsmikehull]

Excel For Freelancers Great thanks, I'll check it out.

[@cristianbesino8315]

Thanks for the tutorial!

[@ExcelForFreelancers]

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

[@nenebinene2194]

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

[@ExcelForFreelancers]

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.

[@mirzakhudrathullabaig7993]

Hello sir Can we bring the multiple sheet in tab ... my data in different sheets with different size (width) and hight

[@ExcelForFreelancers]

Hi it is possible but its not very visually appealing since you have different sizes and widths. Its best to keep it all in a single sheet. I have used Cells as tabs for both vertical and horizontal tab in my latest video here: kzbin.info/www/bejne/n6rVaop_rt2fgMU

[@futuresuperstar4life]

OMG IVE BEEN LOOKING FOR SOMETHING LIKE THIS FOR DAAAYYYYSSS! Pls pls pls can you tell me how I can use these tabs to filter data entered with a date (my shift logs) by weekly, bi weekly, monthly and yearly. It will probably involve a formula.. but also probably a square at the bottom to indicate the week with arrows to move over to the next one. for example. PLEASE you have no idea how long I've been trying to figure this out. I need to figure this out ASAP if you can help in any way PLEASE!

[@futuresuperstar4life]

Can this be done on tables that allows the entry of further/new future data

[@ExcelForFreelancers]

Hi thanks for your comment. I am glad you like the training. Filtering by dates is certainly possible. I have many on that. Please search my channel with "Filter" to learn how to do this. Thanks very much.

[@ExcelForFreelancers]

Also in my project manager and meeting manager videos I have lots of date filters for you to see great examples.

[@futuresuperstar4life]

@@ExcelForFreelancers I cant seem to find a video that specifically says weekly filter. Can you direct me to the video?

[@ExcelForFreelancers]

Hi you can try these video trainings: kzbin.info/www/bejne/rWnKh3-HbM6rnKM kzbin.info/www/bejne/n2myeZudZr9-p8U I hope this helps and thanks.

[@michaelgriffiths3810]

Excellent video. Thanks for sharing.

[@ExcelForFreelancers]

For sure, you are very welcome Michael

[@safeerahmed4474]

Hi sir, wanted to know how to hide columns which has multiple check boxes

[@ExcelForFreelancers]

Hi and thanks you can run an If/Then statement then use the Hidden = true option to hide the columns. 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

[@mansoorckl]

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

[@ExcelForFreelancers]

For sure, you are very welcome

[@saptarshiguin3117]

You are excel god love from India

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that :)

[@ms.vynetesorero1946]

The best tutorial so far. Thank you.

[@ExcelForFreelancers]

Thanks so much Gurong, I am so glad you like it. Here is another way to do tabs that you might like: kzbin.info/www/bejne/n6rVaop_rt2fgMU

[@toml7183]

Hi, Have followed every instruction to the detail. Except I get an error 424 "object required when I run the code on his line : ".Shapes("nettoon").Visible = msoCTrue" You understand that my shape is called "nettoon". Any suggestions ? Thanks for helping me out.

[@ExcelForFreelancers]

I would double check that your "With Sheet1" (or whatever sheet you have is correct) The code looks right as long as your shape name is correct (Mostly likely you are missing the With sheet above, but you can also add the Sheet name to the line to check like: Sheet1.Shapes("nettoon").Visible = msoCTrue 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

[@kevinlynn3797]

Hey Randy Unfortunately I can't upload macros to the server, the spreadsheet has to transfer info to other software. Love that tab trick, it would solve a problem I have atm, with too much info on the one sheet. Ahh well... I downloaded the dynamic drop down sheet, looks great. How you getting that two toned background color?

[@ExcelForFreelancers]

Hi Kevin, Thanks very much for your comment and sorry your server does not allow macros. The two tone background color is created when you right click any cell, go to Format, then the Fill Tab, Then choose Fill Affects and use Two colors. This allows you to chose any two colors giving you a gradient affect. I hope this helps.

[@armsotopre]

Thank for sharing the information.

[@ExcelForFreelancers]

For sure, you are very welcome

[@rousebithol7519]

What is between msoCTrue and True in VBA? How to use them in proper way?

[@ExcelForFreelancers]

Hi thanks Google search can give you a much better explanation that I can. Thanks for your comment.

[@kldpmishra]

Thanks a lot Randy Sir....

[@ExcelForFreelancers]

For sure, you are very welcome

[@sazman68ify]

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

[@ExcelForFreelancers]

For sure, you are very welcome.

[@sridharkrishnappanavanerth3388]

Very nice video sir, I am working on a inventory project were i have text box for 'ID'. ID is of the format ST-AUG-0001, I wish to increment the month from AUG to SEP to NOV etc after each month and also increment sequence 0001 to 0002....very time i click on transfer button in user form. please explain with a video, this is very urgent for me. Thank you in advance.

[@ExcelForFreelancers]

HI thanks so much for your comment. I am glad you like the training. If you need a quick answer on that its best to request it from our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have over 20,000 members who can help you. Much appreciated.

[@techguy9999]

great job and video, thanks for sharing this info

[@ExcelForFreelancers]

Thanks so much Jack. I do appreciate that

[@mmora9294]

Can something like this also be created within PowerPoint?

[@ExcelForFreelancers]

Most likely with images and hotspots this can be created in power point. Minimal coding should be necessary. (You could also do a screen recorder in Excel, then use that video in Power Point) 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

[@asidik]

Thanks for this. I have 2 problems. 1. The With Sheet1 doesn't work. I have to keep typing in ActiveSheet before .Shapes for it to work. Otherwise it comes up with 424 Error. 2. When I click on "TimeClock" The entire columns get hidden including the shapes.. What do I need to do so that the Shapes always appear when the first set of columns get hidden? Thanks so much!

[@ExcelForFreelancers]

HI and and thanks make sure you have the correct sheet # and also make sure you have updated the code to to display the shapes and not hide them using visible = msoCtrue. THere is a free VBA course on my site which you may find helpful here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ Thank you for your Likes, Shares & Comments. It really helps.

[@nunocorreia9360]

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

[@ExcelForFreelancers]

For sure you are very welcome Nuno

[@MAtifRasool]

Hello Sir, Its really a great video to understand VB. I tried all of your said codes to my own sheet and they are working properly. The one thing that I could't understand is how did you make the data appear in the big box. Is there any other code that you might have forgotten to explain. Please help me Sir.

[@ExcelForFreelancers]

Hi all of the data in the cells is just sample data that i put there before I started the video. Its just cells that I typed into. I hope that helps. All the data is there already. I just hide some columns and show other columns with VBA code.

[@bm5763]

When the other columns are hidden as in the code, excel automatically realigns the columns you have chosen to show. This means you need to have the same width of the columns for the data to fit in the content area of the tabs

[@byLokie]

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

[@ExcelForFreelancers]

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

[@ExcelForFreelancers]

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]

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

[@paulaangeladeguia90]

is there an easier way to copy the module to each worksheet? I tried duplicating the worksheet but the codes wouldnt work because "Sheet1" is coded

[@ExcelForFreelancers]

Hi its better to have your data on multiple worksheets then bring it into a single worksheet in a form like these tabs. You can update the sheet names in the code to whatever names you would like. 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

[@roga6111]

you are a MASTER!

[@ExcelForFreelancers]

Thank you so much Rodolfo