Hi everyone,
I'm new to the message board.
I'm attempting to build a spreadsheet that schedules 3 shifts by seniority utilizing Vba.
My Department has 147 employees, and every quarter we give them the opportunity to change their shift preference.
The process is as follows. Each employee is given a 1st & 2nd choice of shifts. all shifts are manned in accordance by seniority.
If a seniority conflict arises, such as multiple employees having the same seniority date.
The solution is that those employees with the same dates be assigned seniority by alphabetical order (last name).
As of right now we are doing this manually. Which as you can imagine, is very time consuming, and is prone to "human error".
While I have done some fairly straight forward Vba programming, this one is causing me some issues.
Any help, or guidance would be greatly appreciated.
Thanks
Tim.
Bookmarks