This webpage contains affiliate links. We may earn commissions for purchases made through affiliate links in this webpage. For more information, please read our Affiliate Disclaimer Policy.
About us - Ablebits.com
We hope that our time-saving tools will become your reliable assistants and help you accomplish your day-to-day tasks quickly and efficiently. 4Bits is a member of Microsoft Partner Network. Add-in Express is Microsoft Visual Studio Industry Partner and Embarcadero Technology Partner
AbleBits.com is a joint project by 4Bits and Add-in Express
4Bits Ltd. is a software development company located in Belarus, Eastern Europe. Established in 2002, the company has grown steadily over the years to become a respected manufacture of software for Microsoft Excel, Outlook, Word as well as add-ins for Office for Mac. Starting from 2013, we've been developing add-ons for Google Sheets and Google Docs as well. The tools turned out to be extremely useful and the number of users has been growing since. In 2020, a small team standing behind the add-ons spun off into a separate company – APPS4GS Ltd. Their focus hasn't changed since and Ablebits remains their trademark.
Partnership
Add-in Express is a privately held software development company also located in Belarus. Established in 1998, the company's primary focus has been on creating development frameworks for Microsoft Office integration and extending Office applications with custom functionality. All solutions published on this web-site are built on the unique technology of Add-in Express. AbleBits.com software products are designed and developed by true professionals with a long-term experience in the Microsoft Office extensibility industry. Over the years we've been adding new features, refining the code and polishing up the interfaces to make the solutions as perfect as they can possibly be.
Source data
For starters, let's get some source data to work on. In our main table on the left, we want to have two picklists in each row, so that selecting a Dept. in the first list only displays Managers for that selected department in the second list. If you change the selection in the main list, the names in the dependent drop-down will update accordingly. The source data for drop-down lists often come from different sources and are organized differently. So, our first step is to structure the original data according to our needs. For this, we are going to create some sort of preparation table that will list all different department names in the header row, and under each dept. name there will be a list of employees working in that specific department. To automate the work and prevent human errors, we will be using the following formulas.