A tip for future reference :) - for the 'HideAll' macro, I think that you can reduce the number of lines to hide the shapes by using the syntax Sheet1.Shapes.Range(Array(enter each shape name here, separated by commas)).Visible=False instead of writing a separate line to hide each one. Nice work!
Hi Brian, Thanks very much. I agree, using Shape arrays to hide all works much better. I did use that in my dashboard masterclass when showing & hiding the button sets) Much appreciated.
Thank you Randy for the incredible lessens! How can we allow the users to select the locked cells on the menu but not change them AND not be able to select any other locked cells?
Hi and thanks for your comment. That comes from the Worksheet selection change event. When a user makes a selection of one of the tabs, the VBA code places the selected row in that cell. I hope this helps and thanks so much.
When you change employee name in the fields (10m30s), the employee information (address, email, phone) does not change. If you have say ~40 employees, where and how would you store their individual information and how would you associate it to these cells and the cells in each vertical tab when just the name is changed? Thank you!
HI and thanks so much. You can use something like Sheet1.Range("A:A").EntireColumn.Hidden = True 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
Folders formation :- Hypothetically We maintain a main folder name base on year, than folder are devided in 12 different sub folder name base on months of year. We save file daily in different sub folder base on it's month of formation. I want code who help me to extract data in different sub folders.
Its a good question and not to difficult of an answer but more than i can provide in a RUclips Comment. I would like to get you many answers on this as well. Can you join our Facebook Group with 5000+ Excel Experts and post your detailed question so we can get you the answer fast? Just join here. Thank so much: bit.ly/groupexcel
Hi i have a few videos on my channel that pertain to that. One that comes to mind is Auto Tab, Save & Load which you can find here: ruclips.net/video/40aYorpxPiU/видео.html
Hi, in this training we hide/show columns on one sheet to demonstrate vertical tabs. To show data from a different sheet you can use cell links. 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.
Thank you so much for such an effort. Truly awesome session it was. learnt a lot from this video. earlier i never knew about this options. One question i have to ask, please advise if i can hide unhide multiple sheets with one tab button? but seriously your tutorial was way beyond awesome. great work Sir!!!!!
Hi thanks so much for your comment. Much appreciated, Yes you can hide multiple sheets with one button in which you assign a macro. Within that macro you can hide (or unhide) multiple sheets.
Urgent question. I got it to work on Sheet1, when I duplicate to have Sheet2 the tabs do not work. Is this meant to be a single sheet workbook? Is there a way I can get it to work? I did a multisheet workbook and just as I was about to use it I realized only Sheet1 worked. Thank you so much for this awesome tutorial!
Hi Jessica, I saw your post on our group as well. You would want to make sure that the code was updated for the new sheet# but i am sure we get it sorted out. (the group is the best way to get help since you can upload your workbook and screenshots and we have 20,000 members there as well. ) I hope we can get this sorted for you. Thanks so much again. These things take time and patience, even for me, so just give yourself a bit of time and you will get it for sure.
Yes its certainly possible to combine both vertical and horizontal tabs, You would just want to hide all of the horizontal tab shapes until that specific vertical tab has been selected. This would not be a problem
Hello and good day to you. Please I want to do the same thing. But I want the tab to link to other sheets, not other columns. So for example, instead of only the vertical tab sheet, the document will contain multiple sheets and the tab will link to this sheet, not to hidden columns in the same sheet. Is there a tutorial for that?
HI thanks you can just activate the sheet you want to go to inside your code such as Sheet4.Activate 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
Thanks very much for your comment. Inventory & Stock has been a popular request, so I will do both a basic (free) video as well as a comprehensive (paid) course :)
Hi Saif, 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 30,000 Members who would love to help you with this. Thanks so much.
Hi thanks for your message. I have been busy and focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, 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.
![How To Create A Contact Scheduler Application In Excel From Scratch [Masterclass + Download]](http://i.ytimg.com/vi/UwN_b0e3iKo/mqdefault.jpg)
![How To Create A Contact Scheduler Application In Excel From Scratch [Masterclass + Download]](/img/tr.png)
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Has anybody told you lately . . . .you're just flippin awesome ! Thank you. You bet that I'll subscribe. Thanks
Thank you so very much, I really appreciate that Mark, so kind of you.
Thank you for your Likes, Shares & Comments. It really helps.
A tip for future reference :) - for the 'HideAll' macro, I think that you can reduce the number of lines to hide the shapes by using the syntax Sheet1.Shapes.Range(Array(enter each shape name here, separated by commas)).Visible=False instead of writing a separate line to hide each one. Nice work!
Hi Brian, Thanks very much. I agree, using Shape arrays to hide all works much better. I did use that in my dashboard masterclass when showing & hiding the button sets) Much appreciated.
Amazing tutorial, straight to the point. Thank you Randy😊
For sure, you are very welcome Robert. Glad I could help
This is absolutely amazing advice
Thank you so very much, I really appreciate that Alam
Thank you Randy for the incredible lessens! How can we allow the users to select the locked cells on the menu but not change them AND not be able to select any other locked cells?
just figured that out w/ a little extra code
Great, glad you got it figured out. Thank you for your Likes, Shares & Comments. It really helps.
Hi Everyone, I don't understand how you make appear the row number automatically in B3. Could you explain ?
Thanks :)
Hi and thanks for your comment. That comes from the Worksheet selection change event. When a user makes a selection of one of the tabs, the VBA code places the selected row in that cell.
I hope this helps and thanks so much.
another great class
Thank you so very much, I really appreciate that
Great work .. Thank you so much.
For sure, you are very welcome Salim
Love watching your excel tutorials, thanks so much for your time! I hope one day I can be an excel expert
Thanks so much. For sure you can become an amazing expert. Just keep at it every day.
When you change employee name in the fields (10m30s), the employee information (address, email, phone) does not change. If you have say ~40 employees, where and how would you store their individual information and how would you associate it to these cells and the cells in each vertical tab when just the name is changed? Thank you!
You have a great question. I made a video just to answer that. Have a look at Auto-Tab, Load and Save here: ruclips.net/video/40aYorpxPiU/видео.html
I cannot get the columns to hide. Is the HideAll a separate macro you created?
HI and thanks so much. You can use something like
Sheet1.Range("A:A").EntireColumn.Hidden = True
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
Awesome, great way of coding, simple yet powerful!
Thanks very much Benjamin
Thanks for great trick and sharing knowledge.
Would you make video on, how to loop over folders and it's sub folder and extract data ?
☺️
Hi thanks i was thinking of making a 'File Manager in Excel' video. What type of data would you like to extract?
Folders formation :-
Hypothetically
We maintain a main folder name base on year, than folder are devided in 12 different sub folder name base on months of year.
We save file daily in different sub folder base on it's month of formation.
I want code who help me to extract data in different sub folders.
Its a good question and not to difficult of an answer but more than i can provide in a RUclips Comment. I would like to get you many answers on this as well. Can you join our Facebook Group with 5000+ Excel Experts and post your detailed question so we can get you the answer fast? Just join here. Thank so much: bit.ly/groupexcel
Fantastic. Thank you very much for sharing.
For sure happy to create these for you. Thanks for your comment.
how did you do the interface of your data? do you have any tutorials about that?
Hi i have a few videos on my channel that pertain to that. One that comes to mind is Auto Tab, Save & Load which you can find here: ruclips.net/video/40aYorpxPiU/видео.html
Beautiful work. Thanks for sharing
Thank's Syed, if you have time, please join our Facebook group here: bit.ly/groupexcel
Joined already
hello i would ask how you show rows and columns from different sheet?
Hi, in this training we hide/show columns on one sheet to demonstrate vertical tabs. To show data from a different sheet you can use cell links. 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.
Thank you so much for such an effort. Truly awesome session it was. learnt a lot from this video. earlier i never knew about this options. One question i have to ask, please advise if i can hide unhide multiple sheets with one tab button?
but seriously your tutorial was way beyond awesome. great work Sir!!!!!
Hi thanks so much for your comment. Much appreciated, Yes you can hide multiple sheets with one button in which you assign a macro. Within that macro you can hide (or unhide) multiple sheets.
Nice video
Thank you so very much, I really appreciate that Humay
Nice video good
Thank you so very much, I really appreciate that.
Urgent question. I got it to work on Sheet1, when I duplicate to have Sheet2 the tabs do not work. Is this meant to be a single sheet workbook? Is there a way I can get it to work? I did a multisheet workbook and just as I was about to use it I realized only Sheet1 worked. Thank you so much for this awesome tutorial!
Hi Jessica, I saw your post on our group as well. You would want to make sure that the code was updated for the new sheet# but i am sure we get it sorted out. (the group is the best way to get help since you can upload your workbook and screenshots and we have 20,000 members there as well. ) I hope we can get this sorted for you. Thanks so much again. These things take time and patience, even for me, so just give yourself a bit of time and you will get it for sure.
Is it possible to add vertical tabs and when I select one vertical tab, it should have multiple horizontal tabs with different info. Is it possible?
Yes its certainly possible to combine both vertical and horizontal tabs, You would just want to hide all of the horizontal tab shapes until that specific vertical tab has been selected. This would not be a problem
Hello and good day to you. Please I want to do the same thing. But I want the tab to link to other sheets, not other columns.
So for example, instead of only the vertical tab sheet, the document will contain multiple sheets and the tab will link to this sheet, not to hidden columns in the same sheet.
Is there a tutorial for that?
HI thanks you can just activate the sheet you want to go to inside your code such as
Sheet4.Activate
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
Please you create stock management controls with your excel
Thanks very much for your comment. Inventory & Stock has been a popular request, so I will do both a basic (free) video as well as a comprehensive (paid) course :)
Thank you for your reply
can this vertical tabs can perform twice in diffrent column...
Matangkuwago Duero Absolutely you can keep multiple columns visible and use each of those for menus. I hope this helps
How about if my tables are comong from different sheets?
Hi, you can just make a value to value exchanges such as Sheet1.Range("A1").value = Sheet2.Range("A1").value
Awesome
Awesome
Awesome
Thanks so much. :)
Wehn I use =B3=ROW(), it shows nothing.
Hi Saif, 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 30,000 Members who would love to help you with this. Thanks so much.
Do you have any contacts number for asking a question ?
Hi thanks for your message. I have been busy and focused on creating some amazing Excel courses for all Excel enthusiasts so I am unable to offer any one on one support at this time. However, 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.