I have an excel spread sheet that has my employees names and overtime
hours listed for each.  The hours change for each pay period.  The
hours are manually entered for each.  I need a way that when the hours
are entered it moves the employee with the lowest amount of overtime
time to the top of the list.  This would mean lowest to highest on
overtime.  This would be in keeping with our union contract of offering
overtime to the lowest then on to the next highest and so on.

Could this be done?  If so how hard would it be?