Drop down lists and pulling data from worksheet based on drop down selection
I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff members in various roles at all schools ranging from cells B2 to O183. I have created a drop down list on the primary worksheet (SESStaff) along with fields that I need to pull staff names from and populate from the (Master) data set and put into those fields for administrators to view based on their drop down selection. I know this is MUCH easier in Access, but the system requires me to do this in Excel. Any help is MUCH appreciated!
|