Hello MrExcel community!
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 the (Master) data set and put into those fields for administrators to view for their schools. I know this is MUCH easier in Access, but the system requires me to do this in Excel. Any help is MUCH appreciated!
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 the (Master) data set and put into those fields for administrators to view for their schools. I know this is MUCH easier in Access, but the system requires me to do this in Excel. Any help is MUCH appreciated!