Create Horizontal AND Vertical Tabs in this Excel Employee Manager [Part 1]

No video

Create Horizontal AND Vertical Tabs in this Excel Employee Manager [Part 1]

Рет қаралды 226,428

Күн бұрын

🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create Both Horizontal AND Vertical Tabs.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/EmplPgrPt1_Wb
📍 View The Full Playlist Here: bit.ly/EmployeeMgrSeries
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:55 - Worksheet Design
8:42 - Conditional Formatting
9:55 - Selection Change Event
12:29 - Tabs Macro
12:56 - Switch Horizontal Tabs
21:31 - Selection Change Event
42:28 - Switch Vertical Tabs
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #employeemanager #horizontaltabs #verticaltabs

Пікірлер: 514

@ExcelForFreelancers 10 ай бұрын

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

@jillianonthehudson1739 5 жыл бұрын

Randy, your channel is a treasure. I've learned more code - and elegant ways of doing things - than i ever have before, and in a short time. You are doing a great job! Thank you and please keep it up!!

@ExcelForFreelancers 5 жыл бұрын

Thank you so much Jillian, I really do appreciate that. I am so glad you like it.

@01daveb1 6 жыл бұрын

Hello Randy. Thank you for your incredible videos. You explain your code and formatting very well and although your videos are not mean to be entertaining, they move along quickly enough that they are easily digestible and are entertaining in their own way. I have learnt so many useful tricks that are difficult to put together when searching for just a one off piece of code, because your projects often show the creation process from blank canvas to finished product. This makes incorporating features into my own sheets so much easier. I particularly liked how you took the time today to explain some of the logic behind the coding very clearly line by line - this makes it easier to apply in other settings without having to just blindly copy your macros verbatim. You are making my own sheets not only work well but look so impressive that my colleagues are beginning to think that I am some kind of excel genius! I feel rather guilty and am starting to think that I owe you some of my bonus! I am really looking forward to the future episodes for this project and think that this will be the most useful 'full project' so far. Thank you for your videos, I am enjoying your presentation style immensely and I hope you continue to enjoy your work for a long time so we can all continue to learn from you. Thanks again for your contribution to helping us understand the murky world of VBA. You are a gem!

@ExcelForFreelancers 6 жыл бұрын

WOW David, thanks so much for your inspiring words. I have saved your comment and when I am tired or frustrated I am going to look back at this comment to give me inspiration to push even harder. Thank you so much. I do have some courses coming up (First will be an Advanced Dashboard Reporting Masterclass which I think you will love. 15+ Hours) I look forward to creating and inspiring people around the world to help them reach new heights and to achieve their own personal goals. Thank you so much :)

@dianamadrid671 2 жыл бұрын

I love your videos, they are very easy to follow and to learn from. This is the first time I learn about VBA and you do an amazing job at teaching. Your voice is also calming which makes it very enjoyable to watch and learn. Thank you!!

@ExcelForFreelancers 2 жыл бұрын

Great to hear and thanks so much. I really appreciate that Diana. If you are new to VBA, 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/

@samonugae 4 жыл бұрын

Dear randy i just want to say a Big Thank you for this. This is incredible.

@ExcelForFreelancers 4 жыл бұрын

You're very welcome Samuel. I am glad I could help.

@kgntci 5 жыл бұрын

What a masterpiece that motivated me to get into VBA stuff! Thank you for the great effort.

@ExcelForFreelancers 5 жыл бұрын

For sure you are versy welcome. We are on Part 16, so this application is moving forward quite well.

@johnrexmopia8593 5 жыл бұрын

thank you very much sir for your videos, i cant imagine that there are still someone like you in this world

@ExcelForFreelancers 5 жыл бұрын

Thanks so much Johnrex, I really do appreciate that.

@DecadentBehaviour 4 жыл бұрын

Thank you so much! Your explanations are concise and easy to follow/learn. Finally did part 1 w/o bugs. I customized it to fit my needs. We shall see how the bugs will perform in the future:-)

@ExcelForFreelancers 4 жыл бұрын

That is great to hear. You are doing well and learning a lot. I am glad I could help.

@wernerhartkopf9745 4 жыл бұрын

You have no idea long ive been search for such an informative and easy to understand help like this. Thank you so much. Ill definitly stay connected. Brilliant class

@ExcelForFreelancers 4 жыл бұрын

Thanks so much Werner. I am so happy I can help. I really do appreciate that. You won't want to miss the Touchscreen POS application and training being released in 12 hours here: kzfaq.info/get/bejne/Z96pqcyguracfKc.html Thank you for your Likes, Shares & Comments. It really helps.

@michaelshultz5584 3 жыл бұрын

This was a big help on my first VBA project at the age of 62 - never to old to learn

@ExcelForFreelancers 3 жыл бұрын

That is Right Michael. We are never to old to learn. I was using Excel for nearly 15 years before I wrote my first line of VBA code. Thanks so much for your comment and feedback. I am glad I was able to help.

@diongumbs8984 3 жыл бұрын

I finally took time to watch this video; and I must say Randy; this video is really awesome. it helped me to learn much more about utilizing excel.

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Dion

@aliawan1977 6 жыл бұрын

Great work, and very well explained. God bless you for your efforts to help people like me, who are totally new to the VBA. Waiting for Part 2.

@ExcelForFreelancers 6 жыл бұрын

Thank so much Muhammad. Much appreciated. I look forward to creating many more for you.

@aliawan1977 6 жыл бұрын

Thank you very much.

@yahya_yg88 6 жыл бұрын

Your style of sheets with this great colors are very beautiful and professional models since I started with you .

@ExcelForFreelancers 6 жыл бұрын

Thanks so much Yahya, I always appreciate your comments.

@jeffpernie4754 5 жыл бұрын

This is outstanding. While I don't want to use this for an employee manager, it is perfect for something else I want to do. I cannot wait to see how you incorporate the employee drop down. One thing that would be perfect for me is if you show how to create a dashboard on a second sheet based on data in sheet one. Using your example, I would need a table with all employees on the left, then a conditionally formatted cell for several columns showing red, yellow, or green based on a date range.

@ExcelForFreelancers 5 жыл бұрын

Hi Jeff, thanks very much. I am going to add the Employee Drop Down list in Part 2 (tomorrow), so that should be very good since its pulling them from a different sheet and I will incorporate auto-complete with that as well. Concerning the Dashboard with data from different sheets I have a full 15 hour course coming up on that within a few weeks so stay tuned. It will blow your mind> Conditional formatting based on Date Ranges would be relatively easy. Once you get your project up, if you have specific questions, please join our Excel For Freelancers Facebook group and post your questions there as we have 10k Excel experts who can help you: bit.ly/groupexcel

@Jojosmith342 Жыл бұрын

You are GENIUS & the greatest VBA instructor. Liked & definately subscribed. Thanks millions for your time, hard work & valuable tutorial. Looking for more lesson. Is that possible to have the employee profile not in the Tab section but on seperate section. Ex: Employee Profile is on upper section, lower section is where the tabs are. You will have the search for the Employee ID or name. When the EmployeeID changes, the contents in Tabs will also change based on EmployeeID. Thanks a lot!

@ExcelForFreelancers Жыл бұрын

HI and thanks so much. Yes certainly it is possible. You can add the general information on the upper area and then use the lower rows to switch tabs. Your search field can be above. There are so many great ways to customize this application. Feel free to download my template and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.

@robertasz9458 6 жыл бұрын

You showed a new world of excel for me. Waiting for next video.

@ExcelForFreelancers 6 жыл бұрын

That's great Robertas. I am happy to hear that and looking forward to creating many more.

@Excellent625 5 жыл бұрын

Thank you Randy, It is an amazing, amazing, and very amazing video. Just a small note, I am now in minute 27:13. I think to fix the issue of the line you have to delet the lower line of row 84 and add an upper line to row 85.

@ExcelForFreelancers 5 жыл бұрын

Hi thanks so much. Yes you can also see in future videos we want to show the upper line of 85, the lower line of 84 is hidden when row 84 is hidden. This same example comes up a few times in Part 2 as well. You are exactly right i cover this also. Thanks so much for watching.

@johnryanmorales735 Жыл бұрын

Best Excel Tutorial Ever.

@ExcelForFreelancers Жыл бұрын

Thank you so very much, I really appreciate that

@asharalo8334 5 жыл бұрын

Sir, thank you so much. I can learn a lot from watching your video.

@ExcelForFreelancers 5 жыл бұрын

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

@nelsonanacay2741 4 жыл бұрын

The Best Tutorial there is

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that Sultada

@samaelgamanywa567 3 жыл бұрын

Hello thank so much for good and useful content. Am having a problem with identifying each column am at the conditioning formula. I noticed in the video as soon as you typed column it turned blue. In mine it's not and not creating the same effect as in the video. Please help.

@ExcelForFreelancers 3 жыл бұрын

Hi Samael, 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.

@user-sg6zh8nb5l 2 жыл бұрын

Hi Randy. Great work as always. Thanks so much for the excellent content. An idea for the tabs to avoid problems if you need to land on a zero. I think an easy way is to number the cells and format them to show the tab name. That way you just have an increasing list of numbers. The new appearing list will have the same numbers as the list above or below so the calculations are the same as the rest already shown in your video.

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks for your comment. I did this video many years ago so i am not sure what you mean by 'land on zero'. Can you most more details, along with a screenshot, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

@nialdean 6 жыл бұрын

Brilliant - i love the way you explain everything, very easy to follow and understand, Thank you!!!!

@ExcelForFreelancers 6 жыл бұрын

Thank you very much Niadean, I look forward to bringing you many more unique videos.

@macman007747 4 жыл бұрын

Hi Randy, I really enjoyed working through that. You have a good style and convey information well. I intend to work through the other parts. I will most likely be purchasing one of your products in the future once I figure out where I am heading with this. Thanks again, keep up the great work! Rob

@ExcelForFreelancers 4 жыл бұрын

Thank you so much Rob, I really appreciate that and so glad I can help. Thanks again.

@johnmaina7762 5 жыл бұрын

Thank you very much.. I've actually built the system with you all through... I've really learnt a lot

@ExcelForFreelancers 5 жыл бұрын

Thanks so much John, I want to build an amazing application BUT... its going to be many parts. IF you (and everyone else) has the patience to watch, Like and share each video, and the intereest remains, I will continue to do it because i feel i can build the best Employee Manager in Excel that exists. (part 2 out in 12 hours here: kzfaq.info/get/bejne/osiRaN1mt9LeqH0.html ) Thanks very much, please feel free to add your suggestions on that video as well once its out.

@usamanaeem8737 3 жыл бұрын

This trick to get Tab Effect is brilliant

@ExcelForFreelancers 3 жыл бұрын

Thank you so very much, I really appreciate that Usama

@adam201192 3 жыл бұрын

I've been following this tutorial and I think It's amazing - I do however have a few problems with vertical tabs and adding more than 4 tabs - Trying to work out how to do this and add around 14 vertical tabs.

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks for your comment. If you share screenshots of your code and workbook in 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.

@nammarcr33737 5 жыл бұрын

Hello Randy I inspired with your Talented Videos & I have seen lot of videos is incredible

@ExcelForFreelancers 5 жыл бұрын

Thanks so much Md, I am glad you really like the videos and training.

@chrisfotoglidis437 5 жыл бұрын

Great work, and very well explained. Good Teacher!

@ExcelForFreelancers 5 жыл бұрын

Thanks so much. I am really glad you liked it Chris.

@ridazaoui233 5 жыл бұрын

Thanks Sir ,you are a master and talent .

@ExcelForFreelancers 5 жыл бұрын

Thanks so much. I am happy I can help.

@singhiallprabhakar3831 2 жыл бұрын

Amazing. Thanks a lot. 😀

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that.

@mishaellasbeautystudio1457 4 жыл бұрын

Hi I'm new in excel, I actually dont know what I'm doing I just follow everything in your video, I am having a hard time with the formula its not updating how will I fix this? Thanks so much I'am learning a lot. For a newbie like me in microsoft excel your videos are easy to understand.

@ExcelForFreelancers 4 жыл бұрын

Hi thanks so much Misha, great to have you here and happy to help. I have set up a Facebook group with over 25,000 Excel professionals to help with your question. Can you join here: bit.ly/groupexcel Upload your detailed question with screenshots and we can help. Thanks so much.

@ibrahim82649 Жыл бұрын

Hi randy, i would like to thank you your videos have been super helpful. I am having difficulties in creating the formular in the VBA can you provide further clarity ?

@ExcelForFreelancers Жыл бұрын

HI Allen, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.

@chuckhamdan1283 6 жыл бұрын

Pretty smart approach! love it.

@ExcelForFreelancers 6 жыл бұрын

Thanks very much Chuck, much appreciated.

@sasavienne 4 жыл бұрын

Simply GREAT. Thank you so much. 🌟 🌟 🌟 🌟 🌟

@ExcelForFreelancers 4 жыл бұрын

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

@danielbarrera1562 4 жыл бұрын

Hi Randy, thank you very much for your videos, I have learned a lot with them, good job!, I would suggest you to create a new app like this but this time creating a database with Access, that would be amazing, Thanks again for your contribution and your patience explaining your macros, Greeting from Mexico city :)

@ExcelForFreelancers 4 жыл бұрын

Hi Daniel, Thanks so much for your comment. I have used Access and i know how powerful it can be. However I am trying to share the idea that Excel can be used independently as an application. The reason for this is when you eventually create and market your own applications, you can then sell these applications around the world, and your customers would need nothing other then Excel. I hope this helps and thanks.

@richardhainsworth9428 6 жыл бұрын

Hi Randy, another great tool....for a suggested add on for next week it would be great to include capability and disciplinary records and if poss some guidance on security that would meet GDPR requirements.....maybe two factor authentication?

@ExcelForFreelancers 6 жыл бұрын

Hi Richard, thanks for the great suggestion. I have written them down, along with your suggestion from your group comments as well. Thanks again for your support

@abdellatifboudelal167 3 жыл бұрын

Amazing thank you so much

@ExcelForFreelancers 3 жыл бұрын

Thanks so much and you are very welcome.

@nicholasporter6693 Жыл бұрын

Thanks for these videos. I have been following them and working out the tutorials to help learning VBA and it's been very helpful. For the part where you hide the cells and show the correct ones when you select a tab, I made the sheet a different size and couldn't make the same formula you used work (the one where you multiply by 20) so I did a more manual process of hiding the rows using range.().hidden = true/false. Is there any negative impacts of doing this other than having more code? Part of the reason I stick with this is because I am still trying to understand those parts as well and wanted to experiment with the syntax of those as well, ontop of not being able to get the other formula to work.

@ExcelForFreelancers Жыл бұрын

Hi and thanks so much. Glad you enjoyed the training. Manual is just fine. If you call out the specific rows, that is going to work without any problems. I did the multiplication by 20 just to reduce writing code and to demonstrate a possible shortcut. It makes perfect sense the way you have done it. In other training videos, I have done it this way as well. I hope this helps and thanks so much.

@aqeelabbasi8772 6 жыл бұрын

Your working is awesome... Thanks. Please upload part 2

@ExcelForFreelancers 6 жыл бұрын

Thanks so much. Part 2 will be coming out on this Tuesday, September 18th.

@oluwabukolaonifadeolawuyi4217 3 жыл бұрын

Hey Randy, thank you for this wonderful tutorial video. It has been of help to me. Please i have a question how did you make the picture template and employee ID. Thanks for your help

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks very much. I just did a search on Google for this picture. You can search for transparent png pictures. I hope this help and thanks.

@vikkidashti 3 жыл бұрын

Hi! I am so glad to find this. I am learning a lot. If you can help me, I copied your formula @11:10 but it doesnt work with me. I see your VBA worksheet has Option explicit, mine do not have. I dont know if does make any difference. Please help anyone maybe?

@ExcelForFreelancers 3 жыл бұрын

Hi Vikki thanks you can simply type Option Explicit at the top, it is just helpful since it requires you to declare variables. 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.

@rkexcel2686 5 жыл бұрын

Dear Sir, Very Useful Video for me Thanks so much

@ExcelForFreelancers 5 жыл бұрын

Thanks so much, you can view Part 2 here: kzfaq.info/get/bejne/osiRaN1mt9LeqH0.html

@vagary1926 5 жыл бұрын

Superb Video! One Question: If I duplicate (copy) the worksheet (Employee 1, Employee 2, etc) what steps need to be taken to ensure that the macros still work properly? My goal is to have multiple worksheets (for multiple employees) that all have the working tabs. Thanks!!!

@ExcelForFreelancers 5 жыл бұрын

Hi Vagary. If you copy the worksheet and all the macros, the one thing you want to make sure of is that the sheet #'s are accurate. For example in the original workbook the sheet numbers may be "Sheet1" however in the new workbook they may be "Sheet2". So that would be the most important thing to check. 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

@charlesschauss501 4 жыл бұрын

Hey Randy, Thank you for your amazing videos. I have a question, if I want to add some vertical tabs, how can I solve the issue in the SwitchVerticalTabs ? Thank you

@ExcelForFreelancers 4 жыл бұрын

Hi Charles thanks so much. You would just need to make adjustments in the formula to allow for vertical tabs depending upon the # of vertical tabs you want to add. 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

@tobievanrhyn4050 5 жыл бұрын

Great tutorials. I would like to add additional vertical tabs, but the calculation keeps giving errors. Please can you let me know how to add and calculate for additional vertical tabs?

@ExcelForFreelancers 5 жыл бұрын

Hi Tobie thanks for your message. It's hard to know what would cause the errors without seeing your code.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

@CCG0D 6 жыл бұрын

Again, amazing as always. Thank you sir!

@ExcelForFreelancers 6 жыл бұрын

Thank you very much

@lmplusmke 2 жыл бұрын

Hello there... AMAZING!... love it.. i wish i had time to learn this stuff... so... can i purchase your finished projects... especificaly this employee manager one? Thanks! MAC

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that. If you need a specific, completed, application you may want to email me with your specifications and I can refer a qualified developer as I just provide the templates. Randy@ExcelForFreelancers.com Thank you for your Likes, Shares & Comments. It really helps.

@anonymousm4328 4 жыл бұрын

Thì is brilliant. Tks you so much. But if hide the number of rows is better. Can you show me pls

@ExcelForFreelancers 4 жыл бұрын

Hi and thanks so much. I appreciate the feedback and comments.

@nerenlakhraj5252 6 жыл бұрын

Hi Randy ... awesome tutorials as usual, thank you. You really inspire me to learn VBA. Just a though, in this tutorial, would you be catering for those in HR to import their current data to this? What about doing a search criteria, salary above or below ... and viewing those results. Thank you once again for your inspirational tutorial videos.

@ExcelForFreelancers 6 жыл бұрын

HI Neren, Thanks very much for your comment. This application could really do whatever 'We' want it to, It's going to be based on yours and everyone suggestions. HR is a massive industry that could really use an application to help solve some of the problems they have. If we have that salary in a table, then we add filters to that table we can then filter all staff based on that salary. (If they are hourly we can also extrapolate the annual pay based on hours per week and weeks per year) We will have an employee table and perhaps we can add filtering into this table. I will add your comments and suggestions to the list. Thanks so much for your feedback

@henryyoung3770 5 жыл бұрын

I'm new to this excel stuff so i'm needing help. in section 45:52 I have 7 tabs and I cn not get the code or formula to add up to make the tabs work I'm at 85 to 212. you have a great video. Thanks for the information its really helping.

@ExcelForFreelancers 5 жыл бұрын

Hi Henry, thanks so much for following and enjoying the videos I hope this helps. To get your questions answered fast, 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

@jhimlozada2940 3 жыл бұрын

Wow!! Thank you.

@ExcelForFreelancers 3 жыл бұрын

For sure, you are very welcome Jhim

@jhimlozada2940 3 жыл бұрын

Thank you! I'm watching all your videos. Thank you sir! For this tutorial.

@growth2509 3 жыл бұрын

Wow Randy, I have never come across these things you teach and I have been using Excel for years. I joined the mentorship program and can't wait to learn more.

@ExcelForFreelancers 3 жыл бұрын

Thank you so much and welcome to the Mentorship Program. With my weekly Modules inside the program, along with the weekly KZfaq videos you are on an amazing learning path. Thanks so much.

@growth2509 3 жыл бұрын

@@ExcelForFreelancers Thank you, I'm happy to be enrolled in your class.

@cherry3464 3 жыл бұрын

Hello Randy, Thank you very much for creating all these helpful videos. I was wondering if you have anything that I can use for tracking one of task at work. I have to keep track of names and address of company's executives, when they gain access to three systems and test scores for two test and mark the task as complete. Which one of your systems do you think I can change to make this possible? Thank you very much. I started making this one but sure if this would be the right one.

@ExcelForFreelancers 3 жыл бұрын

Hi Cherry and thanks I have a series of trainings and workbooks on Task Manager that may be helpful, starting with Part 1 here: kzfaq.info/get/bejne/bpN5eM5e1dPKk6M.html Thank you for your Likes, Shares & Comments. It really helps.

@arlenegriffin4523 4 жыл бұрын

love your videos great help.

@ExcelForFreelancers 4 жыл бұрын

Thank you very much. I do appreciate that Arlene

@od5828 5 жыл бұрын

Looks professional. What if you need to add rows into payroll history? why not create 4 identical sheets, the tab selection gets you to the proper sheet? that way you can keep adding rows.

@ExcelForFreelancers 5 жыл бұрын

The Actual Payroll history data will be on a completely different sheet, so there will be unlimited rows for payroll history. The Employee detail will just show 15 or so payroll histories however I will add a 'Show All' button which will take the user to the Payroll history sheet which will show them all. The idea is to separate the front end 'Employee Manager sheet' with the back end data. This way in future versions we can add Multi-User sharing so that multiple people can edit this workbook at the same time. This week coming this Tuesday I will show you the same idea in Attachments, where the Employee Manager sheet only shows 6 of the most recent attachments, but with one click, a user is taken to the entire attachments sheet and is filtered by employee. Part 4 out tomorrow. Thanks so much for your comment and question.

@jmcrican137 6 жыл бұрын

Hi Randy! I'm learning so much from you! Thank you for what you do! I'd love to see more key employee data capturing such as position, title, and company. Also is there a way to populate specific fields in payroll area that are only associated with say Mgr type employee? Data lives where?

@ExcelForFreelancers 6 жыл бұрын

Hello Mercey, thanks so much for your suggestion. I have written down your recommendations and will do my best to get them in. Thanks again.

@hn3ckl33t 6 жыл бұрын

plz add print out the report, payslip into pdf format. Also would like to see annual leave and sick leave (allow 4 days every 3 months) records. Attaching Contract detail (start and end date) and any support files to the individual employee.

@ExcelForFreelancers 6 жыл бұрын

Thanks very much for your comments and suggestions. I have written down them all and will do my best to add as much as possible.

@hn3ckl33t 6 жыл бұрын

Thank you very much, I'm appreciated your works in sharing knowledge and helping others.

@HoangLe-ln9vm 6 жыл бұрын

I like it, because it helps for me pass difficult now

@ExcelForFreelancers 6 жыл бұрын

Thanks very much Hoang, I am really happy you like it. Cam On Ban

@federicoromero918 5 жыл бұрын

Hi Randy, can you also show how to create a printable form showing certain data from this project. I am planning to do this with a little modification to show residents from a facility instead of employees. Some sort of a database.

@ExcelForFreelancers 5 жыл бұрын

Hi Federico, actually I just did something similar in Part 11, in which we created Printable ID Cards which shows specific Employee Data, you can view this training (and download the workbook) from here: kzfaq.info/get/bejne/rMuTkpWkvMnDio0.html

@k102stone 5 жыл бұрын

Another Great video.. Thanks. Could you add time off request and vacation time or sick leave for the payroll as a category these are all items that would need a place to live in a payroll system. Are you going to add in Security levels to this workbook because it will have SS numbers stored within the book? Thanks again

@ExcelForFreelancers 5 жыл бұрын

Hi thanks for your suggestion. Yes to answer your questions the Time off, vacation, sick design aspect I am going to add in this Part 2 (Release tomorrow) and the Security aspect is also a yes but that will be added at the very end. (I am not sure when this series will end. It depends on all of the ideas and suggestions) Thanks very much

@Jackjohn2000 2 жыл бұрын

Hey! love this vid, would this work on google sheets? Thanks

@ExcelForFreelancers 2 жыл бұрын

Hi and thanks so much. This works just on the full version of Microsoft Excel. Thank you for your Likes, Shares & Comments. It really helps.

@jawariakhatoon9791 2 жыл бұрын

Hi. I want to create aquaintance roll which shows data such that: step-I user has to select a month. step-II to select DDO code. and it shows data of selected DDO code for the selected month. Basically Your tutorial inspired me to create such payroll but not succeeded till now. Please make a video for this too. Thanks.

@ExcelForFreelancers 2 жыл бұрын

HI Jawaria, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.

@k102stone 5 жыл бұрын

Could we also look at creating custom reports for payroll, taxes and auditing? Thanks

@ExcelForFreelancers 5 жыл бұрын

Thanks for the suggestion. Yes the reporting is important but would come towards the end of this application. Nice Ideas, I have written them down.

@TheWeeHenry 3 жыл бұрын

Congratulations. As usual, another first class, easy to follow tutorial. May I ask a question? Is not the 'Dim' statement a shortened version of 'Declare in memory" as per the old phrase 'REM' which I always took to be 'Remember.?

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks i am glad you liked the training. There is a great explanation of the origin of the DIM statement here: docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/statements/dim-statement

@josefinalewar295 5 жыл бұрын

thank you very much sir ... really helped me. God bless you

@ExcelForFreelancers 5 жыл бұрын

For sure, you are very welcome, happy I can help

@zakaralli 5 жыл бұрын

Very usful share, thanx a lot.

@ExcelForFreelancers 5 жыл бұрын

For sure you are very welcome. Happy to help

@tdzung92 5 жыл бұрын

Hi Randy, Thank you for your amazing videos. I found it very helpful, you have given very clear and understandable guide. I have a question that I would like to modify the tabs name. For example, instead with General Info, I want to change it to Person Info. Or in the future, if I want to change name of these tabs, can I do that? How can I do that? I hope to see your reply in this case. Much appreciate that. Thanks again!

@ExcelForFreelancers 5 жыл бұрын

Hi thanks very much for your comment and glad you love the videos. You can easily just change the values of the cells which will change the names. Changing the names will not affect the performance of switching tabs.

@williammai7571 3 жыл бұрын

Thank you for teaching me very useful too. But i get a problem at 14:38, specifically .Range("5:84").EntireRow.Hidden = True. After typing this line, it turns into yellow, thus when i click in info or payroll history, the "employee" box doesn't work like you did in your video. May you tell me how to fix it?

@ExcelForFreelancers 3 жыл бұрын

Hi and thanks, this may happens sometimes if the sheet is incorrect, if you have hidden the rows already or if you have shapes that cannot fit on the existing sheet. With that said, 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 40,000 Members who would love to help you with this. Thanks so much.

@ahmedsalim880 5 жыл бұрын

its really nice .. thank you very much .

@ExcelForFreelancers 5 жыл бұрын

Thank you very much Porter

@durrani1983 3 жыл бұрын

just one request sir once the whole is ready if you can give a demo at very last on how to work on it as during making i m focusing on how its all done and by the time i try to copy u on my pc i m lost on how to use the app.

@ExcelForFreelancers 3 жыл бұрын

HI and thanks so much. This application is complete all of the way to Part 21. You are welcome to download it and customize it to fit your requirements. If you need help with this you can create a post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

@sabeelmughal1 6 жыл бұрын

Thank you sir great work can you help to make retail shop pos with cash ,Credit and invontery manager in excell

@ExcelForFreelancers 6 жыл бұрын

Hi thanks so much for your feedback. I am unable to take on projects myself however we have an amazing group of Excel Professionals with over 10,000 experts so please feel free to join and post your project here: bit.ly/groupexcel

@jazlynhernandez1642 3 ай бұрын

This is awesome! Thank you. I went to add a 5th vertical tab, and updated the Sub SwitchVerticalTabs() line of SelRow = Right(ActiveCell.Row, 1) - 5 to SelRow = Right(ActiveCell.Row, 1) - 6, and copied a fifth one under it, but it didn't work. Could you tell me what I need to change to fix it? Also, if I wanted to add a second set of vertical tabs in the horizontal drop down, would that still work?

@ExcelForFreelancers 3 ай бұрын

Hi , 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.

@nammarcr33737 5 жыл бұрын

Hello sir Do you show me how to skip blank cells? when we put a data entry in visible cells when press tab button it Avoid blank cell

@ExcelForFreelancers 5 жыл бұрын

Hi Md. you can simple add an if/then statement within the AutoTab macros so that only cells that contain values are followed such as If activecell.value empty then 'Your tab code here end if 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

@nammarcr33737 5 жыл бұрын

Thank you sir for your valuable reply

@Shadrach.O 5 жыл бұрын

Hi your video is wonderful great and inspiring. thumbs up. do you have videos on VBA coding for excel? i would love to know how to use them on excel

@ExcelForFreelancers 5 жыл бұрын

Hi thanks so much. I have around 80 videos on KZfaq at this time as well as my Advanced Excel Dashboard Masterclass which includes VBA Coding on Excel here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass

@theamazingreviews5830 3 ай бұрын

Format with =cell=column() doesn't work to me :( Maybe it depends on language of Excel? If I use =cell=Colonne() I have error...

@ExcelForFreelancers 3 ай бұрын

@adriandavies-dear2421 4 жыл бұрын

Hi Randy Here’s a quandary for you. I Have been at this one nearly all day, I have the horizontal tabs working perfectly. However, with the vertical tabs, in your video course you have calculated, within the VBA, the selected row down to 1 through to 4 to make the visible rows show correctly, however, if you have more than 9 controls vertically, this causes a minus figure + the target row which will give you the incorrectly shown rows, I have tried to calculate to the last 2 digits using SelRow = Right(ActiveCell.Row, 2) which then causes an issue with the calculations to get the target rows to show. Have you a workaround or solution for more than 9 vertical controls? I hope that all makes sense? I am using this lesson in conjuction with your latest video on Fleet expenses. Thanks Adrian

@ExcelForFreelancers 4 жыл бұрын

Hi Adrian, thanks so much for your comment. Using a calculation to switch vertical tabs is a cool trick because it allows you to use a single macro for all tabs. However it is not necessary and can be a bit confusing. If you want you can always use separate macros for each tab, hiding the exact rows you want. such as .Range(5 & ":" & 15).entireRow.hidden = false. The manual way, on a per row basis takes a bit more time to program but its also a lot more straight forward then using the complicated formula, especially when things are not even. Thanks so much.

@mohammedismail7275 4 жыл бұрын

Thank you Sir. Could you please advise how i can edit the Tab button. I would like to edit the tab cell,

@ExcelForFreelancers 4 жыл бұрын

Hi you can easily change the contents of the cell to whatever you want, simply by typing new text in the cell (You may have to pause the code) 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

@mauricelee2219 5 жыл бұрын

hi sir, very nice video, thanks for sharing

@ExcelForFreelancers 5 жыл бұрын

For sure Maui, thanks for watching . Make sure you check out the entire series. We are building an amazing application.

@TheMaseno1 3 жыл бұрын

Hello there, thank you for great works. But when i run the horizontaltabs they said method 'Range' of object '_worksheet' failed. How to fix that error Randy.

@ExcelForFreelancers 3 жыл бұрын

Hi , 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. Cam on ban

@austinsamamarajr 4 жыл бұрын

Hey Randy, I enjoyed the course but I have little issue with my vba coding, can you help me solve that out? the problem I face with it is by inserting pictures. I followed your step by step tutorial but I still face difficulties with only inserting pictures. Thanks

@ExcelForFreelancers 4 жыл бұрын

Hi Austin, thanks for the comment and I am glad you like the training. The best way to get help with your issue, is to join and create a post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 20,000 members and i know we can get this fixed for you, Please make sure to share the code you are using and any screen shots. Much appreciated.

@72jihad 5 жыл бұрын

Dear, Thanks a lot. I did Part 1 well but I have a problem that when I click on F4, the cell F2 changes color from white to light blue. There should be some wrong thing

@ExcelForFreelancers 5 жыл бұрын

HI thanks Jihad. its hard to know what is wrong however please double check your conditional formatting rules for that cell. 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

@loidaasar487 4 жыл бұрын

Hi Randy, can you please advise as to how i can change the tab name of the sample file i downloaded example General info?

@ExcelForFreelancers 4 жыл бұрын

Hi thanks so much. You can pause the code, then change the name and reset the code. 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

@mdsaiful6294 2 жыл бұрын

Nice video good 👍

@ExcelForFreelancers 2 жыл бұрын

Thank you so very much, I really appreciate that Saiful

@hazelbarila4436 3 жыл бұрын

Hi! I'm so grateful for your videos and I'm learning a lot but I do have a problem This specific code in the VBA doesn't work ".Range(FirstRow & "." & FirstRow + 19).EntireRow.Hidden = False" What should I do?

@ExcelForFreelancers 3 жыл бұрын

Hi Hazel, thanks so much and I am glad you liked the video. Please replace the period with a colon such as : .Range(FirstRow & ":" & FirstRow + 19).EntireRow.Hidden = False 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

@hazelbarila4436 3 жыл бұрын

@@ExcelForFreelancers I have changed the period to a colon but still it has an error.

@brettralston3599 7 ай бұрын

I get the same error @@hazelbarila4436

@gamesofduster9817 4 жыл бұрын

Hi Randy...thx for the video's...however by the first step to show witch menu you choose the bottomline will disapere won't work for me. The bottom line will still be there. I tryed manny times but sttill the same. Is there a option that I need to activated? Regard Jeroen

@gamesofduster9817 4 жыл бұрын

Found it....instead =$b$2=Column() it is =$b$2=KOLOM()

@ExcelForFreelancers 4 жыл бұрын

Great and thanks for your comment. i am glad you were able to find the solution. Thank you for your Likes, Shares & Comments. It really helps.

@Bumbus977 5 жыл бұрын

Hello Randy and thank you very much for this video. I'm having problems with my conditional format in min 33:33, when I enter =Mod(Row(),2=0 and complete my formating I receive that there is a error with the formula. Looking forward to learn more from you in the comming weeks about this excel sheet Logi

@ExcelForFreelancers 5 жыл бұрын

Hi Logi, you are missing an end parenthesis after the 2, like this: =Mod(Row(),2)=0

@Bumbus977 5 жыл бұрын

@@ExcelForFreelancers Thank you very much :) I really enjoy these videos and am looking forward to learn through this series

@ExcelForFreelancers 5 жыл бұрын

For sure you are welcome, and so glad you like this series (last one is tomorrow for the Employee Manager) Then we will have some exciting new training each Tuesday

@johnwatkins39 4 жыл бұрын

awesome video, can you make a video for an excel project for a training manager?

@ExcelForFreelancers 4 жыл бұрын

Hi John, thanks very much and I am glad you like the training. I do not have much background information on projects for training, so perhaps in the future after some research. Thanks so much

@asifamir4335 4 жыл бұрын

HI ther.e.. First of All, its really nice effort and i am really thankful for your guidance .... ...secondly ... can i have these codes please.... there are some mistakes due to which codes are working properly...

@ExcelForFreelancers 4 жыл бұрын

Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

@akkintouch 5 жыл бұрын

Dear Randy, is there something extra I need to do if I have a multiple horizontal tabs and multiple vertical tabs inside each other.. How can I separate those rows. Note: am using hide rows style Hope to hear from you. Thank you

@ExcelForFreelancers 5 жыл бұрын

Hi Avi, you would want to use a single macro to hide everything (which runs every time) and then another macro to show only the rows you want. You will also have to duplicate the menu for each set of rows you want displayed since you are using rows and not columns to hide. I hope this helps.

@akkintouch 5 жыл бұрын

Much appreciated Randy. Thank you so much for the reply. I think I will try that. Also will this make any difference if I have my cells equally merged? With the merged cells I was able to run horizontal tabs. But vertical tabs I am not able to. Is there anything I need to keep in mind when dealing with merged cells? I have used target.count > 4 As my I have 4 cells merged together. I guess am in the right direction. Please guide me.

@ExcelForFreelancers 5 жыл бұрын

HI Avi, yes you have the right idea with the Target.Count > 4 based on merged cells. We want to try to avoid merged cells when we can. I use them of course just not as often. When having multiple horizontal and vertical tabs it requires good planning and good design. It's no fun to make changes after your coding is done and the math can get tricky. Try to keep things clear, like use 100 rows per tab, so that its much easier. You can use the merged cells but just make sure that they are contained in a single group to be shown or hidden.

@akkintouch 5 жыл бұрын

@@ExcelForFreelancers Dear Randy, thank you for the inputs. I remade my excel document so that there is no merged cells. i also made 3 different horizontal tabs and 3 different vertical tabs to make my sheet work. But i have a problems getting the row values right. In the example you have used the right extream value of the row, eg. 25 = 5. But what happens when it comes to 30, the row value will become 0, and the first row becomes (-1). will you be able to expain me the logic behind when row becomes 0. Am sorry to ask , i know there is FB group, but if if its possible here then please let me know. thank you again in advance.

@ExcelForFreelancers 5 жыл бұрын

Hi Avi, please upload your workbook in our group so our members can help you with this. Since i am unable to see the application its difficult for me, or anyone, to let you know of the exact details.

@user-ij9xh6ui3e 4 жыл бұрын

Hello Sir, Your work is so nice and easy to learn. I need those icons. can you please give me those icons or give me a solution for downloading those icons...... Thanks in advance sir.

@ExcelForFreelancers 4 жыл бұрын

Hi there, you can download this file and the icons using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

@BytesizedTechTips 5 жыл бұрын

Hi I'm getting an error when I entered the 1st code please help me. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("E4:H4")) Is Nothing Then Range("B2").Value = Target.Column End If End Sub

@ExcelForFreelancers 5 жыл бұрын

Hi I do not see anything wrong with the code but we would have to see your workbook or a screenshot of your code to understand what is going on. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel and create a post with your workbook, screenshot and details so we can help you. Thanks very much.

@emmanuelilukwe6264 5 жыл бұрын

Hello, I am on the 2nd Video. My Picture does not change after the first change. I always go to refresh in the VBA section for it to change. Kindly assist urgently please I don't want to stop here. I so much love your videos that i downloaded all in one night I noticed the Picture Path do change when i add a picture but the picture itself doesn't update/change

@ExcelForFreelancers 5 жыл бұрын

Hi Emmanuel thanks so much for trying out the code and watching the videos. There may be some issues with your code, so you would have to check line by line using F8 to step through it. 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

@Paul-wx5uc 4 жыл бұрын

Hi thanks for these tutorials, is there any chance of doing a beginner's tutorial series for the beginner in excel like me? I hope you can

@ExcelForFreelancers 4 жыл бұрын

Hi Paul, thanks very much for your comment. There are already so many great channels here on KZfaq that each beginner and intermediate Excel I am not sure if that would be helpful. Check out some great channels such as Leila Gharani, Excel is Fun, Excel VBA Is Fun and Mr. Excel. I hope this helps and thanks so much.

@johnjacobjinglehimerschmid3555 4 жыл бұрын

@@ExcelForFreelancers To be honest ..... I struggled to learn VBA before the advent of youtube. In 1994 or so I delved into MSFT and vba .... Over the years learned lots ... But the one thing that got me learning more and more was the macro recorder. And then "DEBUGGING" the code, aka stepping through code one line at a time, the recorder isn't perfect but what is. With the advent of people like EFF here that has ready made books... Download them and then step through the code behind buttons. You will learn quite quickly. Just my $0.02

@waynegrakowsky2714 5 жыл бұрын

This is a two part comment/request. First i have been following along on many of your videos, great job. Is it possible to add more lines to each of the vertical tabs. Instead of 25 i would like to use 30 or more. I have tried multiple times but it is not working. Also, with vertical tabs i would like to use a second or third vertical tab in some of the other horizontal tabs. Will it be the same code or do i need to rename it to a specific one? Thanks

@ExcelForFreelancers 5 жыл бұрын

Hi Wayne, thanks very much for your comment. it is certainly possible to add more rows to each tab. You would just have to adjust the formula within the code to accommodate this. Since I cannot see your workbook and code it would be difficult for me to determine the actual issue you are facing. Vertical tabs can be used in any # of horizontal tabs. The best would be two start a new workbook (instead of customizing mine) and plan out the entire tab process, mapping out all of the rows and columns, then programming it based on those conditions. 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

@cmard22 4 жыл бұрын

with the code .Range(FirstRow&":"&FirstRow+16).EntireRow.Hidden=Flase I keep getting and error that states "Compile Error: Expected: List Seperator or )" and I cant seem to fix it (18:55) in video.

@ExcelForFreelancers 4 жыл бұрын

Hi , Thanks for your comment. Make sure you add spaces just as I have and made them in the video. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks. 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.

@richardvargas9102 5 жыл бұрын

For the last portion pertaining to the vertical Tabs on payroll detail I have 8 sections not 4, so after I select the 5 to 8 tabs it bugs. I believe the section of code can be done a little differently to accommodate First time trying VBA out

@ExcelForFreelancers 5 жыл бұрын

Hi Richard, it should just be a few small changes in the code formula. If you need help with code, feel free to upload your workbook in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel . We have 20,000 members who can help you.

@richardvargas9102 5 жыл бұрын

Thank You For replying back so quickly, I have sent the request in for the group

@jamiep1645 5 жыл бұрын

Good ideas. Any thoughts on why excel 2016 does not want to accept the ":" command?

@ExcelForFreelancers 5 жыл бұрын

Hi James, it depends what line that is in and what language pack installed. (I doubt its a 2016 issue). 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

@philipmcdonnell7168 6 жыл бұрын

Ooh this looks like fun. I've just done something similar but my code is as clumsy as a dysphasic penguin. I wonder if I can squeeze this into lunchtime?

@ExcelForFreelancers 6 жыл бұрын

HI Philip, Thanks so much. It's been so long since i have run into a dysphasic penguin, so I would not worry too much. If your lunchtime is at least an hour you can squeeze it in. I always appreciate your comments and suggestions.

@shoshoabebe 5 жыл бұрын

Hi sir again and again thank you so much for teaching me , actually there's a problem i didn't know where is it i tried hard to find it but i couldn't is there any way to send my file to you to see ?? even if i should pay i will actually you deserve a lot and i am grateful for you .

@ExcelForFreelancers 5 жыл бұрын

Hi the best way to get help on your issue is with our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 18,000 Excel Experts and you can upload your file and get help right away on your issue. Thanks again for your comment.