I'm new here, so please bear with me. I'm working on a excel schedule for work. The cells contain a formula that populates the employee name if they are scheduled to work, and leaves a " " if they are off duty. I used the VBA recorder to perform the sort, but when I run the macro to sort the list, the non blank cells do not sort. The intention is to sort the columns by seniority using a custom list, and move non-blank cells to the bottom of the column. It sorts by seniority, but the non-blank cell do not move to the bottom. I tried sorting by color, but that didn't work with VBA. I also thought about filling the cells with zzzz and conditionally formatting the text color to match the cell color, but I would like to find another solution. Any help is appreciated.
Bookmarks