Scheduling participants

Thank you both, these have both shown me some things to implement. I'll make an attempt at the actual structure I need with these approaches and might be back to get a clarification.
thanks again

I have gotten one copy of the list working on my schedule, but the PM list (on this file, the PM assignments, using the PM list on the right, in the FRI tab, isn't behaving correctly, it's missing a couple of the first entries from the list and when selected the names don't disappear of the list correctly.

I've also been trying to through the reference lists onto a separate tab, here in the MON AM-PM tab, and at first AM seemed to work. I figured I could use one list of the participants (on the REF tab) and replicate the number columns from the participant list (I've only tried changing the Tuesday columns so far, the rest are just copies right now)

What am I missing when I reference the participant list while it is over on the REF tab?
Why isn't the dynamic list working correctly when I duplicate it and change the references to columns accordingly?

Okay... I've got more of a handle on this, and I have both the morning and afternoon assignments for Monday pulling people from the 'Unassigned' list...

But I've noticed a couple snags while showing this to the end users for usability discussions:

1) I anticipated filling the assignments initially with cut and past operations. They are still removed from the assignments, no problem, but CAN be pasted in there more than once. Is there anyway to prevent that? At worst, I imagine I can color-code duplicates for manual removal. Actually, maybe that's the only way to solve this.

2) I'd love to alphabetize the various assignment lists. Can one column be shuffled around dynamically like that without affecting the ones around it (though, actually, they ALL should be, so that's not a concern)

3) I'd like assignment lists to collapse to fill gaps when someone is removed. Is that possible?

4) In the data validation drop down for each assignment list space, could I put a -remove- option to delete the current person, without putting 'remove' into the assignment list? I imagine it would be another function somewhere looking over the pages for 'remove', deleting it, and then collapsing the list as mentioned above.

Tim

It took me a minute to find what you did... I had forgotten the Week tab was still in there. I've hidden it for now, though, thanks! Yes, I can replicate that for the other days.
I was focusing on getting Monday working before I worried about echoing the entries on the Weekly schedule... but this is great, I can get them set up. I appreciate that.