Automation

Let's say I have a list of employees and for each employee there is a volunteer status (e.g. Selected, Waitlisted, Ineligible, Removed).  Now, we have a specific count of employees Selected and Waitlisted.  If an employee decides to be removed, we want the next employee under Waitlisted to be moved to Selected and then next person as Ineligible moved to Waitlisted.  This way there is always a consistent volume.  Any ideas how I can accomplish that in automation?

------------------------------
Michael Sargent
------------------------------