I can't seem to find the right formula to accomplish this task;
I have a spread sheet with multiple tabs, I want to take the names (B3:B61) and work shift "0600-1400" (C3:C61) from either Master or Alpha Sheet, place the names in alphabetical order on Week 1 Sheet B6:B25. There are a total of 14 employees working the 0600-1400 shifts in Master or Alpha Sheet C3:C61
I have a spread sheet with multiple tabs, I want to take the names (B3:B61) and work shift "0600-1400" (C3:C61) from either Master or Alpha Sheet, place the names in alphabetical order on Week 1 Sheet B6:B25. There are a total of 14 employees working the 0600-1400 shifts in Master or Alpha Sheet C3:C61