I wanted to create a process to which my union can select work in a fillable Excel form (that is password protected) by emailing it to our members.
The member with the highest seniority would get the email, make their selecting in the combo boxes by selecting:
1) Day or Night
2) Spareboard, Relief, Regular, or Vacation board
3) select the run, route, and key they wish to work for said board (winter, spring, summer, fall boards).
4) school extra: yes or no
Choose: run, route, key
If the first person with the highest seniority selects a certain run said run, route, key or position (spareboard slots 1-80) to be removed from the available list for the next senior member. I can't seem to find a formula or tutorial to explain how I can achieve this.
Any help plz?
The member with the highest seniority would get the email, make their selecting in the combo boxes by selecting:
1) Day or Night
2) Spareboard, Relief, Regular, or Vacation board
3) select the run, route, and key they wish to work for said board (winter, spring, summer, fall boards).
4) school extra: yes or no
Choose: run, route, key
If the first person with the highest seniority selects a certain run said run, route, key or position (spareboard slots 1-80) to be removed from the available list for the next senior member. I can't seem to find a formula or tutorial to explain how I can achieve this.
Any help plz?