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

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

@ExcelForFreelancers

4 жыл бұрын

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

AMAZING AS ALWAYS!

@ExcelForFreelancers

6 жыл бұрын

Thanks again. Much appreciated.

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

@ExcelForFreelancers

5 жыл бұрын

For sure no problem, happy to help

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

@ExcelForFreelancers

Жыл бұрын

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

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

@ExcelForFreelancers

4 жыл бұрын

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

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

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome

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

@ExcelForFreelancers

6 жыл бұрын

Hi, you are very welcome. I am glad you liked this horizontal tabs tutorial. Feel fee to try out the Vertical Tabs Tutorial which is even easier here: kzread.info/dash/bejne/hJ-AppN6pKmXc9o.html

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

@ExcelForFreelancers

5 жыл бұрын

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

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

@ExcelForFreelancers

3 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

5 жыл бұрын

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

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

@ExcelForFreelancers

5 жыл бұрын

That is so great to hear. I am so glad you like it. Not to add more features, but if you liked this tab video check out this cell-based tab video (its even simpler, but maybe not as beautiful) kzread.info/dash/bejne/m62mm7mCqdvSesY.html

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

@ExcelForFreelancers

5 ай бұрын

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

the tutorial was amazing. Thanks, lot.

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

5 жыл бұрын

Hi Mohamad, Thanks very much. I am glad you like the videos. I do have a user form on opening here: kzread.info/dash/bejne/YpWcu9GyZa-ZlcY.html

Great video, Thanks for sharing!

@ExcelForFreelancers

6 жыл бұрын

You are very welcome. Happy to share.

Awesome video Randy ! Keep the great work !

@ExcelForFreelancers

4 жыл бұрын

Thank you very much. I do appreciate that Jerome

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

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

5 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

Thank you so much Sameer. I do appreciate that.

Thanks. Just what I'm looking for.

@ExcelForFreelancers

5 жыл бұрын

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

The best tutorial so far. Thank you.

@ExcelForFreelancers

5 жыл бұрын

Thanks so much Gurong, I am so glad you like it. Here is another way to do tabs that you might like: kzread.info/dash/bejne/m62mm7mCqdvSesY.html

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

@ExcelForFreelancers

3 ай бұрын

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

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

@ExcelForFreelancers

4 жыл бұрын

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

Priceless, thank you.

@ExcelForFreelancers

6 жыл бұрын

You are very welcome. happy to help.

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

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

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

Great to have this

@ExcelForFreelancers

6 жыл бұрын

Nagireddy B For sure happy to make them. Thank you for your comment

Thanks brother, God Bless You 😀

@ExcelForFreelancers

5 жыл бұрын

For sure, you are very welcome

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

@ExcelForFreelancers

6 жыл бұрын

Hi thanks so much I am glad you liked this. You may also like the Step By Step Wizard which includes a summary in which you can print here: kzread.info/dash/bejne/X3WapKaqlNq7aM4.html

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

@ExcelForFreelancers

5 жыл бұрын

Graicias Mi amigo Alvaro

Excelente video, gracias por compartir su conocimiento.

@ExcelForFreelancers

6 жыл бұрын

De Nada Amigo :)

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

@ExcelForFreelancers

3 жыл бұрын

Thank you so very much, I really appreciate that.

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

@ExcelForFreelancers

6 жыл бұрын

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

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

@ExcelForFreelancers

4 жыл бұрын

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

Excellent and very useful. Thanks

@ExcelForFreelancers

6 жыл бұрын

Thanks very much :)

Simple yet effective. Thank you 🙏

@ExcelForFreelancers

4 жыл бұрын

You are very welcome, happy to help.

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

@ExcelForFreelancers

5 жыл бұрын

For sure you are very welcome Rana

Thanks so much for this tutorial... Super informative!

@ExcelForFreelancers

6 жыл бұрын

You are very welcome. Happy to create these for you :)

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

@ExcelForFreelancers

6 жыл бұрын

For sure Luis, Glad I can help. Thanks for your comment.

Thanks brother, God Bless You

@ExcelForFreelancers

5 жыл бұрын

Thanks so much. I am glad you liked it.

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

@ExcelForFreelancers

6 жыл бұрын

De Nada Mi Amigo :)

Just too good. Enjoyed watching this.

@ExcelForFreelancers

6 жыл бұрын

Thanks so much Awesh, much appreciated.

excellent tutorial, thanks

@ExcelForFreelancers

6 жыл бұрын

You are welcome and thanks for your comment.

Great explanation 👍👍. Thank you very much.

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome.

Very helpful. Thank for your video!

@ExcelForFreelancers

5 жыл бұрын

Thank you very much. I do appreciate that.

Bless you bro!! Just perfect!!!

@ExcelForFreelancers

2 жыл бұрын

Thank you so very much, I really appreciate that.

Really nice explanation, thanks for the help.

@ExcelForFreelancers

6 жыл бұрын

For sure you are very welcome. Happy to create these for your Joseph

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

@ExcelForFreelancers

5 жыл бұрын

For sure you are very welcome Nuno

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

@ExcelForFreelancers

Жыл бұрын

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

great job and video, thanks for sharing this info

@ExcelForFreelancers

5 жыл бұрын

Thanks so much Jack. I do appreciate that

Thats great..................... I was looking for this work .....Thanks

@ExcelForFreelancers

6 жыл бұрын

Nusrat Ali Excellent happy to help

Thanks for the tutorial!

@ExcelForFreelancers

3 жыл бұрын

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

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

@ExcelForFreelancers

6 жыл бұрын

Stephen Scotney Thanks very much. I am glad you liked it

Excellent video. Thanks for sharing.

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome Michael

This is amazing and simple. You're great

@ExcelForFreelancers

2 ай бұрын

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

Simply Awesome ...

@ExcelForFreelancers

6 жыл бұрын

Thank's so much. Glad you liked it.

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

@ExcelForFreelancers

5 жыл бұрын

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

@stephaniegallentine

5 жыл бұрын

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

@arthurbirnie7924

9 ай бұрын

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

Thank for sharing the information.

@ExcelForFreelancers

5 жыл бұрын

For sure, you are very welcome

Thanks for this amazing video

@ExcelForFreelancers

6 жыл бұрын

For sure you are very welcome

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

@ExcelForFreelancers

Жыл бұрын

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

Great Video! Very helpful.

@ExcelForFreelancers

5 жыл бұрын

Thanks so much. IN 12 hours I plan to release a new video on both Horizontal and Vertical Tabs and I think you will love it. (This link will go live at 9/11/2018: kzread.info/dash/bejne/m62mm7mCqdvSesY.html )

Nice lesson. Very useful. Thanks a lot.

@ExcelForFreelancers

6 жыл бұрын

Thanks so much. I am glad you like it.

Thank you, that 's great tutorial

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome Cam on ban.

thanks for this wonderful vid :)

@ExcelForFreelancers

6 жыл бұрын

Thanks very much. I am glad you liked it.

thanks man, really awesome

@ExcelForFreelancers

6 жыл бұрын

Thanks so much. Happy to help and glad you liked it :)

thank you man it's a great work keep it up :) :)

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome I am glad you like it.

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

@ExcelForFreelancers

6 жыл бұрын

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

@saurabhm19782

6 жыл бұрын

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

thanks buddy!! learned a lot

@ExcelForFreelancers

5 жыл бұрын

For sure, you are very welcome. I am glad you liked it.

Fantastic! Thanks

@ExcelForFreelancers

5 жыл бұрын

Thanks so much Pietro, I am glad you liked it

So Great! Thanks

@ExcelForFreelancers

5 жыл бұрын

For sure you are very welcome Yuriko

very good thanks

@ExcelForFreelancers

6 жыл бұрын

For sure you are welcome. Tomorrow I have another video, similar to this except vertical tabs. I think you will like it. Subscribe to get the announcement when its out.

This is just fabulous sir, Thanks a Lot

@ExcelForFreelancers

Жыл бұрын

Thank you so very much, I really appreciate that Anirudh

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

@ExcelForFreelancers

3 жыл бұрын

Thank you so very much, I really appreciate that Sanntosh

@mayboli7438

3 жыл бұрын

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

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

@ExcelForFreelancers

2 жыл бұрын

Thank you so very much, I really appreciate that.

This was really helpful.

@ExcelForFreelancers

6 жыл бұрын

Thanks very much. Happy to help

Thanks for sharing such useful files !!!

@ExcelForFreelancers

3 жыл бұрын

My pleasure 😊 Alam

Thanks

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome.

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

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome.

Great dude, keep going...

@ExcelForFreelancers

5 жыл бұрын

Thanks so much. I am glad you like it.

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

@ExcelForFreelancers

3 жыл бұрын

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

@wayneedmondson1065

3 жыл бұрын

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

@ExcelForFreelancers

3 жыл бұрын

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

Great work Thank you very much

@ExcelForFreelancers

6 жыл бұрын

Thanks very much. Happy to create them for you Shahroze

Always top application thank you Mrs Excel

@ExcelForFreelancers

Жыл бұрын

For sure, you are very welcome Messaoud

Thanks a lot Randy Sir....

@ExcelForFreelancers

3 жыл бұрын

For sure, you are very welcome

This is super awesome.

@ExcelForFreelancers

3 жыл бұрын

Thank you so very much, I really appreciate that.

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

@ExcelForFreelancers

3 жыл бұрын

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

wooow pretty cool very nice subject

@ExcelForFreelancers

6 жыл бұрын

Thanks very much. :)

very useful, thank you

@ExcelForFreelancers

6 жыл бұрын

For sure you are very welcome

THANKS ALLOT ITS REALLY AWESOME

@ExcelForFreelancers

6 жыл бұрын

For sure, you are very welcome. happy to help

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

@ExcelForFreelancers

4 жыл бұрын

For sure, you are very welcome

Very good One

@ExcelForFreelancers

6 жыл бұрын

Thanks very much :)

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

@ExcelForFreelancers

5 жыл бұрын

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

Nice video advice

@ExcelForFreelancers

2 жыл бұрын

Thank you so very much, I really appreciate that.

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

@ExcelForFreelancers

6 жыл бұрын

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

Amazing work sir....

@ExcelForFreelancers

4 жыл бұрын

Thank you very much.

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

@ExcelForFreelancers

6 жыл бұрын

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

awesome video

@ExcelForFreelancers

6 жыл бұрын

Thanks so much, I am glad you liked it.

Thank you very useful

@ExcelForFreelancers

5 жыл бұрын

For sure you are very welcome Mouhyiddine

Nice work Randy. Top drawer yet again.

@ExcelForFreelancers

3 жыл бұрын

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

@philmustoe5438

3 жыл бұрын

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

@ExcelForFreelancers

3 жыл бұрын

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