1 min readfrom 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!

submitted by /u/ScrewPCx
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article