Sorting question sort of
Just picture a calendar and these are names listed for a particular day (each day is made up of a group of cells in my case each day has 47 cells aligned in a column for example B5:B47) see picture below (I hid some rows to keep the pictue small). Each color represents a different workgoud and the grey cell are the Next Line cells.
|