How To Automate Common Processes in Excel with Tab Control
In the last two videos I explained how the Tab Hound and Tab Control add-ins can save you a ton of time with your everyday Excel tasks. Here are links to the two videos in case you missed them.
These videos also contain a lot of Excel tips and shortcuts, and I hope you can learn something from them.
In this new video I am going to demonstrate how you can automate some common tasks with the Tab Control add-in.
You will learn:
- How to add multiple sheets to your workbook from a list of sheet names.
- How to re-order your sheets quickly with drag-and-drop.
- How to automate the process of hiding and unhiding multiple sheets for a monthly reporting package.
I also answer questions from the last video, including when Tab Hound and Tab Control will be available.
The Future of Tab Control
In the video above I give a simple example of how Tab Control can be used to automate the process of hiding and unhiding sheets. This is a common process that many of us do for periodic reports.
This is just one example of how Tab Control can be used for process automation. It really only scratches the surface of what is possible with this tool.
Using a spreadsheet (TabControl sheet) for the inputs gives us a lot of possibilities for different features and uses. Based on your suggestions, I’m currently working on ways to split (export) sheets into different files, apply detailed protection properties, copying sheets, and more.
I’m looking forward to learning how you use this tool. I know we will be able to create ways to help automate some of your repetitive tasks.
Please leave a comment below with any questions or suggestions.
Thank you! 🙂
Tab Hound and Tab Control are Now Available
The Tab Hound and Tab Control Add-ins are now available. Please click the link below to learn more about it.