Hello,
I am new to VBA programming, and I want to see if there is a way to run a certain Macro.

In Column A (Group) I want to be able to enter how may groups I have.

In Column B (Members), I want to put how many members are in each group.

On a separate worksheet (Sheet 2), I will have a list of numbers (1-100 for example). I want these numbers to be assigned randomly to the members of each group. So, for example, if Group 1 has 5 member, 5 random numbers. Group 2 has 3 members, 3 numbers, Group 3 has 17 members, 17 numbers, etc.

The numbers of Groups, members, and random numbers will change each time, so is there a way to base the Macro on what is entered in Column B?

Hopefully this is clear, it wasn't explained to me very clearly either

Melissa