Good evening excel geniuses,

I expected to be able to find what I was looking for already asked, but haven't found it and was hoping if you would please help.

Each session there are 5 task groups to be completed and there are 14 people to complete the tasks. The sessions will continue on into the foreseeable future. The number of task groups and the number of people it takes to complete a task group will always remain a constant. The number of people may expand and contract a little due to people possibly not showing up for a session, drop outs, or new additions.

Listed across the top of my excel sheet are the tasks. Task 1 (T1) requires 1 person to complete the task, as do T2 and T3. T4 requires 4 people to complete and as does T5. This puts 11 people to work and allows 3 a day off.

I would like a macro that when activated would pull from the list of people (the list has already been organized in the generally preferred assignment order) and would generate the next session.

The caveats are there cannot be duplicates/repeats in a single session, nor duplicates/repeats in a specific task group until everyone has else has already had a turn completing the task. Also, if I generate a roster for that session and someone does not show up, I need to be able to manually remove that person from the generate roster or if needed manually add someone without it breaking the spreadsheet. Similar in nature would be if I were to completely remove or add someone to the list of people that the spreadsheet would not break.

Is this possible?

Would any of you out there please be willing to work with me in successfully completely this type of tool?

Thank you for your time.