Schedule with Split Shifts, and Sort by times in/out

**russellm84** · 12-19-2018, 07:05 AM

Hi there, first time posting, but I've been using excel for several year, but not very advanced, nor taken any classes.
I created this workbook today that I want to use at work.
In the first sheet, it is simply a schedule that has been copied and pasted from our store's scheduling program, so can't change the formatting on that
I have a blank page on how the daily sheets are formatted.
Then on each page, i have the appropriate data pulled from the full schedule starting with column Z. The tables (not Excel Tables) for each type of position have formulas that extract the data from the daily schedule which fill in only the names of the people scheduled for that day, and their shift.

The problem I've run into, and not sure where to start, is that there will occasionally be split shifts, as you can see with Monday and Tuesday.
Manager 3 has a split shift on monday, but the monday sheet is only displaying the first shift.
Manager 1 has a split shift on tuesday, same problem.

Then, what I'd like to do, is have each area of the sheet sorted first by the in times of the employees, and then the out times

**rcm** · 12-19-2018, 11:31 AM

This routine will fill all the days with the shifts
I am also including your excel file with the routine and link included. The button is in the schedule ranges tab.

Please Login or Register  to view this content.

**russellm84** · 12-19-2018, 04:07 PM

Thanks for that, but it seems to be copying the same shifts to every day, instead of the appropriate day to each sheet. I don't know what the code is doing in order to find what I need to fix

**rcm** · 12-19-2018, 04:28 PM

My bad. It was not looking at the right columns. I fixed it. Give it a try.

**russellm84** · 12-19-2018, 05:27 PM

Thank you. I actually figured out a formula based solution using ranking based on the in times of the employees. Then I used a helper column next to each field on the sheet to fill in the schedules using ranks in ascending order