Cascading Drop-Down Menus In Excel for a Tracker
Posted on 2010-09-03
I'm sending out a tracker to several hunder people to fill out and so that the data is standardized I've done some drop-down menu data validation based on some menus I've defined on a different sheet in the same workbook.
For one of the drop downs "Org. Code" I'm wondering if it can eliminated some of the 50+ codes based what the user selects from the "Org. Title" menu.
Basically every Org. Title matches up to 1-3 Org. Codes it would be alot easier if the user only had to choose from the 1-3 relevant Org. Codes rather than the 50+.