Hi all,
Trying to find the best way around an issue I have come accross.
I'm running events, and have a list of staff who are all open to work 3 events, and they all have unique ID's.
I have 3 columns, event 1,2,3, and I need to allocate the staff out to each event. I need to do this without duplication, but also I need to somehow show in the availability table that they have been allocated, i.e at the end I can see who's still free?
This is the simplified version of what I need. I know about conditional formatting, so can highlight duplicates if needed but was hoping for a way that they no longer are available to pick, as opposed to just being red.
I'm building a staff rostering tool from scratch so any help appreciated.
Cheers.
Trying to find the best way around an issue I have come accross.
I'm running events, and have a list of staff who are all open to work 3 events, and they all have unique ID's.
I have 3 columns, event 1,2,3, and I need to allocate the staff out to each event. I need to do this without duplication, but also I need to somehow show in the availability table that they have been allocated, i.e at the end I can see who's still free?
This is the simplified version of what I need. I know about conditional formatting, so can highlight duplicates if needed but was hoping for a way that they no longer are available to pick, as opposed to just being red.
I'm building a staff rostering tool from scratch so any help appreciated.
Cheers.
