Arrange golf teams

I run a spreadsheet that manages golf tournaments. i have to group
the # of players evenly as possible on each hole once they are entered into the tournament. since the number of players varies from tournament to tournament the math gets complicated trying to get the groupings right. i can do the math on paper but do not know how to code the math in a macro. this would save me a ton of time if someone can figure this out. i have attached a sample .xls that includes all the info i could think of a person needs to see what is going on. If i am asking to much i understand and will remove the thread. Thanks for your time.

See attached.

There are formulas in the top two rows that make the number of holes and players random at the moment.

Not sure what you're trying to do; maybe this.

I got rid of the macro.

I'll let you take it from here.

You're welcome, thanks for the feedback.

Simplified ...