Colleagues,
I would like Excel to auto-populate a master shift schedule.
I have three office locations with three different shift schedules in worksheets named "1", "2" and "3". Another worksheet, named "master" would display shift schedules from worksheets 1, 2 or 3 based on location (the data is in cells A5 through H37). The idea is to enter location information in the master worksheet's drop-down menu ("1", "2" or "3"), which would then auto-populate schedule information from worksheets 1, 2 or 3.
Likely, I will need to use a combination of Vlookup, Index, Match, plus set up the drop-down menu--but I am honestly feeling a little lost.
Can anyone on this forum offer specific advice on how to best pull this off?
Thanks in advance,
Daniel
Bookmarks