Hello,

I have some administrative staff who create 3 month's of appointments every 3 months, assigning employees from a list to handle one day at a time, in a rotating fashion.

One set of employees rotates twice before another set comes into the rotation once.

I.E. Set A - Set A - Set B - Set A - Set A - Set B.

Is there a way so setup a macro to run this?

And on top of that - could the employees be selected form a check box - so when employees drop out of Set A or Set B (not switching between sets, just leaving their set's rotation for a while) the macro does create appointments with their names in the title?

Thanks,
Tom