VBA to have permutations and combinations to make groups

We have a group of 100 people and may regularly receive such no of people,our job is to make N number of groups and rotate them make them such combination day wise so that each person mingle with other and know each other

For example 100 people can be made 10 groups and each person will move to another group each day in sitting arrangement.
So what if we have 50 people and we have 3 days training program, similarly will be such task of mingling in front of us, we will get data of all participants in excel

Hard to understand your intention. Please be more specific on your output requirement with an concrete example.

still vague. There are too many combinations. What is your criterion?

Originally Posted by Torontohrb

Hard to understand your intention. Please be more specific on your output requirement with an concrete example.

Sir, its like when you get a batch to train them who do not know each other, to increase bonding among them and to know each other how many groups and how you will arrange sitting arrangement each day so that after lets say 5 days they know each other, it can be 5 days program 7 days program and no of people in batch will vary . Sometime you will get 50 people to train sometime 100 like that.

sir,thanks for your kind response ,its good and as expected but it does not give flexibility of changing no of people in a group
for example suppose no of people are less so if i want to make group of 3 people rather than 5

in this case i can make group of 5 only,kindly help for that too