In my new spreadsheet I have a list of employees in 192 departments. The
sheet is sorted by department, division, then employee name.

I have a blank line between groups--the blank line is for percentage
calculations.

I also have due dates (you may have seen my earlier post). Let's say that
I've managed to color code the due dates (way overdue, just or soon to be
overdue, and fine).

I would like to sort them with by color but keep them within the departments
and not move the blank lines.

When I try this, all the blank lines are sort together. Is there anyway, to
sort the due dates for Dept. A without interfering with the row separating it
from Dept. B. Keep in mind, I have 192 depts to deal with.

Thanks.