Quote Originally Posted by MarvinP View Post
I play a lot of golf and created a spreadsheet and some code that should handle this problem.
.
Hi MarvinP,

Do you have any good ideas on how to adapt your code to increase the number of groups? Ideally we want to create 4 groups Ladies, Div1, Div2, Div3 so that Ladies would be distributed evenly (as in your original) and then the remaining places filled with respect to Div - so that groups would be filled Lady1, Div3a, Div2a, Div2b then Lady2, Div3b, Div2c, Div2d and Lady3, Div2e,Div1a, Div1b etc so that players generally play within similar standards to each other whilst maintaining the random aspect within the overall structure?

I have had a look at the code in VB but I am struggling to see where to start,

Sorry if this seems an impossible question!!

Any thoughts greatly appreciated.

Regards,