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

[@ExcelForFreelancers]

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

[@jillianonthehudson1739]

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]

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

[@01daveb1]

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]

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]

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]

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/

[@wernerhartkopf9745]

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]

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

[@michaelshultz5584]

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

[@ExcelForFreelancers]

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.

[@samonugae]

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

[@ExcelForFreelancers]

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

[@kgntci]

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

[@ExcelForFreelancers]

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

[@johnrexmopia8593]

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

[@ExcelForFreelancers]

Thanks so much Johnrex, I really do appreciate that.

[@DecadentBehaviour]

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]

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

[@diongumbs8984]

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]

Thank you so very much, I really appreciate that Dion

[@macman007747]

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]

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

[@ΚωνσταντίνοςΠρούντζος]

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]

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.

[@aliawan1977]

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]

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

[@aliawan1977]

Thank you very much.

[@jeffpernie4754]

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]

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

[@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? [e-mail] Thanks so much.

[@Excellent625]

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]

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.

[@yahya_yg88]

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

[@ExcelForFreelancers]

Thanks so much Yahya, I always appreciate your comments.

[@adam201192]

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]

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.

[@oluwabukolaonifadeolawuyi4217]

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]

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.

[@robertasz9458]

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

[@ExcelForFreelancers]

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

[@nialdean]

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

[@ExcelForFreelancers]

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

[@charlesschauss501]

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]

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

[@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.

[@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.

[@johnmaina7762]

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

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/opPEZq1rh9Gtrqs ) Thanks very much, please feel free to add your suggestions on that video as well once its out.

[@richardhainsworth9428]

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]

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

[@vikkidashti]

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]

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.

[@cherry3464]

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]

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

[@samaelgamanywa567]

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]

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.

[@k102stone]

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]

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

[@nammarcr33737]

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

[@ExcelForFreelancers]

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

[@vagary1926]

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]

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

[@nerenlakhraj5252]

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]

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

[@tdzung92]

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]

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.

[@johnryanmorales735]

Best Excel Tutorial Ever.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@lmplusmke]

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]

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

[@Jackjohn2000]

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

[@ExcelForFreelancers]

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.

[@k102stone]

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

[@ExcelForFreelancers]

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]

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]

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

[@jazlynhernandez1642]

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]

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.

[@tobievanrhyn4050]

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]

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

[@jmcrican137]

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]

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.

[@Shadrach.O]

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]

Hi thanks so much. I have around 80 videos on KZbin 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

[@eduardopena7700]

Great video easy to follow. I am making my own sheet but I am having compile error with the separator ":" in the macro. How can this be fixed?

[@donaldfakoory3152]

I am having the same issue.

[@donaldfakoory3152]

Find the solution in another comment: You need to leave a space between the & both side and both of them.

[@ExcelForFreelancers]

Thanks so much, yes correct a space is needed. I am glad you found the solution. Thank you for enjoying the training.

[@eduardopena7700]

@@donaldfakoory3152 Thank you! As a newbie I also realized that I was using the wrong sheet when using With sheet.

[@donaldfakoory3152]

@@ExcelForFreelancersThank You for doing this, I am very new to VBA and Macro' s I actually had to do it over five times (Slow learner) I did not realize that I had to save it as a Macro enabled Spreadsheet to get back to it. I just saved it as Excel worksheet, and when I tried to open the macro's they weren't there. At the moment I am just copying what is being done without taking much time to understand what exactly the statements mean. So I will re-watch the video's to make sense of each instruction. Once again thanks so much. Donald

[@asharalo8334]

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

[@ExcelForFreelancers]

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

[@federicoromero918]

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]

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

[@danielbarrera1562]

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]

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.

[@adriandavies-dear2421]

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]

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.

[@usamanaeem8737]

This trick to get Tab Effect is brilliant

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Usama

[@mishaellasbeautystudio1457]

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]

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.

[@growth2509]

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]

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

[@growth2509]

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

[@mohammedismail7275]

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

[@ExcelForFreelancers]

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

[@sabeelmughal1]

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

[@ExcelForFreelancers]

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

[@chrisfotoglidis437]

Great work, and very well explained. Good Teacher!

[@ExcelForFreelancers]

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

[@Bumbus977]

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]

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

[@Bumbus977]

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

[@ExcelForFreelancers]

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

[@henryyoung3770]

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]

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

[@williammai7571]

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]

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.

[@akkintouch]

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]

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]

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]

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]

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

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.

[@od5828]

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]

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.

[@Paul-wx5uc]

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]

Hi Paul, thanks very much for your comment. There are already so many great channels here on KZbin 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]

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

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]

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

[@gamesofduster9817]

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]

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

[@ExcelForFreelancers]

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.

[@loidaasar487]

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]

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

[@Moc2Talk]

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

[@ExcelForFreelancers]

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

[@jamiep1645]

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

[@ExcelForFreelancers]

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

[@hazelbarila4436]

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]

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]

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

[@brettralston3599]

I get the same error @@hazelbarila4436

[@nammarcr33737]

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]

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]

Thank you sir for your valuable reply

[@sasavienne]

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

[@ExcelForFreelancers]

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

[@shoshoabebe]

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]

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.

[@ridazaoui233]

Thanks Sir ,you are a master and talent .

[@ExcelForFreelancers]

Thanks so much. I am happy I can help.

[@johnwatkins39]

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

[@ExcelForFreelancers]

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

[@nelsonanacay2741]

The Best Tutorial there is

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Sultada

[@philipmcdonnell7168]

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]

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.

[@aqeelabbasi8772]

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

[@ExcelForFreelancers]

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

[@TheMaseno1]

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]

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]

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]

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.

[@roxannramirez336]

how can i costmuize the typ of payrool i would like to do. we have subcontractors and we have to add all of there runs at the end of the week we have alot of ordes for each subcontractors and we dont tack out texs . but your dose tack out texs and we do 10-99 i love this

[@roxannramirez336]

and we dont pay buy the HR

[@ExcelForFreelancers]

HI thanks very much. Once this application is complete in a few weeks you will be able to customize it exactly how you want. I hope this helps

[@brianwarner493]

This is great, but is there a way to shift across columns instead of rows with this method?

[@ExcelForFreelancers]

Hi Brian, yes I use multiple columns in a different training video in which you can see here: kzbin.info/www/bejne/p6m5nWWsn7yFi9k

[@brianwarner493]

@@ExcelForFreelancers Hey Randy. Thanks for getting back so quickly. Yes, I've seen that video, and have used your method to develop an employee training tracker with 100+ training for 80 ish employees. I have 20 horizontal tab buttons; 1 for each training batch. The worksheet is however running super slow now, so, to speed it up I'm hoping to use your cell tab method instead of the shape button macros (that I spent so much time doing lol)

[@ExcelForFreelancers]

HI Brian, you can just duplicate the cell-based tabs. So if you have a set of 20 tabs, and you wanted to use column based hiding/showing you would then need to duplicate these same 20 tabs across all of your 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

[@brianwarner493]

@@ExcelForFreelancers Hi Randy, thanks for getting back, yes duplicating the outline across the columns makes sense. My issue is how to code the hide/show of columns using the cell click method. It seems so intuitive using rows (portion for rows as example) [.Range(FirstRow & ":" & FirstRow + 19).EntireRow.Hidden = False] etc... But I have no idea how to code for hiding/showing columns.

[@jawariakhatoon9791]

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]

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? [e-mail] Thanks so much.

[@chuckhamdan1283]

Pretty smart approach! love it.

[@ExcelForFreelancers]

Thanks very much Chuck, much appreciated.

[@nareshkumar-ik4nr]

Good day Sir, Is it possible to add horizontal tab like we add sheet by pressing +. Because i have 3 different tab bit 3 one is i want to add for n times (because there is only on variable). Thanks you

[@ExcelForFreelancers]

Hi thanks for your question you can use the sendkeys command to run any macro. In your case pressing the + you can add your macro and then do what 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

[@nareshkumar-ik4nr]

@@ExcelForFreelancers i will post on page. Thanks

[@hn3ckl33t]

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]

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]

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

[@rithvikyalakanti5826]

Hi Sir. Thank You. Can you please make a video on assigning tasks and projects to the employees.

[@ExcelForFreelancers]

Hi and thanks so much. I do have that already. Please search my channel for "Task Manager" Thanks so much.

[@bornikfik3869]

Hey Randy I've got problem with the macro at 18:18 at line 6 Run-time error 424 Object required

[@ExcelForFreelancers]

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

[@KB-AFG]

Hi sir thank you for nice videos, would you please do a tutorial for shipping company. which is shipping the goods for traders by trucks.

[@ExcelForFreelancers]

Hi thanks for your comment and suggestion. I do not know too much about that industry but i am happy to learn. Can you email me with all of the details and I will do my best to create a video in the future? [e-mail] Thanks very much.

[@durrani1983]

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]

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.

[@asifamir4335]

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]

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.

[@6121987ful]

Hi Randy, I need some help to build data entry form for my business. Is there any way I can get in touch with you. Many thanks Tj

[@ExcelForFreelancers]

HI and thanks very much. While i am unable to take on projects, if you want to email me a complete project scope i can refer it to a qualified developer. [e-mail] I hope this helps and thanks.

[@CCG0D]

Again, amazing as always. Thank you sir!

[@ExcelForFreelancers]

Thank you very much

[@nammarcr33737]

You have used condition Formatting Rule for Rows and column in one sheet (=B3=Column()) but How to set condition Formatting Rule to multiple worksheets ? Is it's possible please reply me

[@ExcelForFreelancers]

Hi Md, yes its possible you would just have to add an Or command in the formula such as =or('Sheet1'!B3=Column(),'Sheet2'!B3=Column()) 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]

@@ExcelForFreelancers Thank you for reply & your advice Genius man ok I will join in Facebook for ahead questions

[@ExcelForFreelancers]

Thanks so much. Great to have you there.

[@nammarcr33737]

@@ExcelForFreelancers How to intersect for sheet1 and sheet2 method in Excel vba coding If not intersect(Target,worksheets("Sheet2 ").range("E86") is Nothing then End if

[@ExcelForFreelancers]

You would put the code within the sheet editor (not in a module) so no sheet is required (*You cannot intersect two cells from two different sheets at the same time)

[@andrewchan8850]

Hello Randy, It said Expected list separator or ) when i wrote "." How do i fix that? Thank you

[@andrewchan8850]

i mean ":"

[@ExcelForFreelancers]

Hi Andrew I would still need to see the entire line of code to know what the issue is. Thank you.

[@violetcabbage]

I thought same my issue as .Range(FirstRow&":"&FirstRow+19).EntireRow.Hidden=False

[@rkexcel2686]

Dear Sir, Very Useful Video for me Thanks so much

[@ExcelForFreelancers]

Thanks so much, you can view Part 2 here: kzbin.info/www/bejne/opPEZq1rh9Gtrqs

[@singhiallprabhakar3831]

Amazing. Thanks a lot. 😀

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@arlenegriffin4523]

love your videos great help.

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Arlene

[@richardvargas9102]

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]

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]

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

[@huihui5148]

Mr. Randy, I am facing an issue with this tutorial, as i try to create my own staff information form using your this method, but i am stack in the middle of create the multiple row for the select option folder, as the tutorial show the active cell is able to deduct as the last row digit is 6-9, but what if my data have some is from 6-9 and some is the last digit is less then 4

[@ExcelForFreelancers]

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 50,000 Members who would love to help you with this. Thanks so much.

[@huihui5148]

@@ExcelForFreelancers ok, I already send my file to the group. Tq so much

[@fasthomefixconstruction3404]

HI guys i'm having a problem (18:31) where they use ":" it says compile error: Expected list separator or ) what must i do???????

[@ExcelForFreelancers]

Hi thanks it would be hard to know the exact problem unless you share your code and your workbook screenshots. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel and upload all of the details so we can help.

[@cmard22]

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]

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.

[@raedagram2511]

Is there away we can keep scan item to each employee such as their payday checks and keep it on separate file for each one of them

[@ExcelForFreelancers]

Hi Raed, yes certainly. As long as you add the employee ID with the employee record you can always filter the list by ID. I hope this helps and thanks so much.