•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically sorting employee list based on seniority and accepted/declined OT
An employee overtime call list goes in order by seniority, but then if an employee declines or accepts > 4 hours of OT, they get moved to the end of the list. If they only accept 4 hours or aren't called/available due to vacation, already scheduled, etc then they stay where they are.
How can I make a call list that automatically adjusts / sorts the call list order based on whether someone declines and accepts > 4 hours or not?
Example Emp 1 (declined) Emp 2 (Accepts 4 hours) Emp 3 (Not available) Emp 4 (Accepts 8 hours)
Would end up as Emp 2 Emp 3 Emp 1 Emp 4
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site