I need a macro to do the following:
I have a dinner wheel list of 64 people(or couples) including 16 group leaders. I need a macro that will sort this list 12 times(12 months) so that each person is in a different group with a different group leader.
If possible??? please write the macro so that (for future groups) it could be 5 people or 2 in each group, in case the group size changes.
If you are willing and capable please post here in the forum. I will then send you an email with the attached document.
Please feel free to change my format if needed to work within your formula.
Once I confirm this works then I will send you a paypal donation for $25 and recommend or rate you on this board(if thats done here).
Thanks Mike
I have a dinner wheel list of 64 people(or couples) including 16 group leaders. I need a macro that will sort this list 12 times(12 months) so that each person is in a different group with a different group leader.
If possible??? please write the macro so that (for future groups) it could be 5 people or 2 in each group, in case the group size changes.
If you are willing and capable please post here in the forum. I will then send you an email with the attached document.
Please feel free to change my format if needed to work within your formula.
Once I confirm this works then I will send you a paypal donation for $25 and recommend or rate you on this board(if thats done here).
Thanks Mike