I have a workbook with two worksheets. One worksheet contains
Supervisor information for vacation scheduling for his/her group
The other sheet contains a list of all employees for the shop.
There are 7 Supervisors with about 20 employees each. I use
a data validation to a list to change the supervisor name on the
sheet and and I want to be able to draw only his employees
from the second worksheet and show their names in a range of
cells on the first worksheet. Can someone point me in the right
direction as to how I can accomplish this? I'm not even sure
what to put in the search criteria to find any information on this.