SDThomas99
New Member
- Joined
- Sep 29, 2009
- Messages
- 14
I have a huge workbook with many hidden worksheets where data on a form (worksheet #1) pulls data from. The form has a picklist that has over 400 names (currently, when a name from the picklist is selected the data on the form updates for that person). My task is to break it up to where it is easier to manage. I need to be able to make a picklist or something like it where I can choose a department - once the department is chosen a list is presented with employees in that department. Once the employee is chosen, then the data in the form updates for that employee.
Is there an easy way to do this?
Your help is greatly appreciated!
Is there an easy way to do this?
Your help is greatly appreciated!