Hi,
I am wondering if someone could help me write a macro, even just to get started.
Basically what i want to do is allocate staff to an Examination Room. I need a certain number of invigilators on a certain date
for each examination room. The number of staff needed i have calculated in a column for each date.
What i want to do is for a macro to check the availability of the staff for each date and assign the examination room to another coumn (booked). I need to go through this range x number of time (the number of staff required on a certain date)
I don't know if i'm explaining this well but any help is appreciated!
Thanks,
Dominica.
I am wondering if someone could help me write a macro, even just to get started.
Basically what i want to do is allocate staff to an Examination Room. I need a certain number of invigilators on a certain date
for each examination room. The number of staff needed i have calculated in a column for each date.
What i want to do is for a macro to check the availability of the staff for each date and assign the examination room to another coumn (booked). I need to go through this range x number of time (the number of staff required on a certain date)
I don't know if i'm explaining this well but any help is appreciated!
Thanks,
Dominica.
