volleyball

[Guest]

I have two colums
Colum a =events/dates
colum b =staff

I would like to assign events to each of the staff without repeat the staff
for the same date of the event. ie frank = test a at 10:30 am; frank is not
allow to be schedule for an event on the same date if already he was pick. I
need a formula for the 75 events and 35 staff available.

 

[Guest]

Raphael, I think that you should think to use access forms instead of excel
to do what you want.
If you continue to plan to use excel I would say that :
-create a list of events (DATA > VALIDATION)
-create a list of staffs (DATA > VALIDATION)
-create a worksheet containing several columns
1. a Date
2. a Time schedule
3. an event
4. a staff
-create a macro which will check each line of the previous worksheet that a
date - time - staff is unique
-create a button and put it on your taskbar

But, don't forget to define exactly your dictionnary: do you need a start
date and an end date; do you need only a start date? Do you accept to pick a
staff if he is staffed on an event that will be ended 10 minutes after the
beginning of the next event?

think twice because time-related problems are often difficult to manage,

I hope that I helped you a little bit on the project management because I
don't have time to write and test the macro I'm talking about.

Cordially,

A. B.
A.