BusyBossLady
New Member
- Joined
- Oct 16, 2017
- Messages
- 1
I need to know if what I'm wanting to do is even possible. I am trying to make a rotating schedule (4 weeks different schedules each week) for associates in multiple departments at my store. I want to have a data validation list that when I select Department 1 it will pull up all rows of schedule options for that department. I know how to use VLOOKUP to link one row of data to an option in a data validation list, but is it possible to link more that one row to that option?
For example, I would have CSA 1, CSA 2, AND CSA 3. All 3 would be on different 4 week rotations and be listed on individual rows. If I were to select Department 1 from a drop down list, then all scheduling options for that department would appear, if I were to select Department 2 which has say 4 CSAs instead of 3, then their rotation options would appear.
I hope this makes sense. I know this will involve multiple sheets if possible and I am fairly good with excel, but I am confusing myself trying to figure this out.
For example, I would have CSA 1, CSA 2, AND CSA 3. All 3 would be on different 4 week rotations and be listed on individual rows. If I were to select Department 1 from a drop down list, then all scheduling options for that department would appear, if I were to select Department 2 which has say 4 CSAs instead of 3, then their rotation options would appear.
I hope this makes sense. I know this will involve multiple sheets if possible and I am fairly good with excel, but I am confusing myself trying to figure this out.
