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. I have a column 'number of staff' needed for each date.
What i want to do is create a macro to check the availability of the staff (in a column) for each date (column C) and assign the examination room
(column M) to the coumn G (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. I have a column 'number of staff' needed for each date.
What i want to do is create a macro to check the availability of the staff (in a column) for each date (column C) and assign the examination room
(column M) to the coumn G (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.
