I have 48 employees assigned over 4 locations and divided into 3 shifts. I want to create a sheet where I select the shift and the employees assigned to that shift populate to cells divided into their assigned locations. To complicate things alittle more. I need each employee cell to be able...