I'm new to this forum, but I've already seen some great stuff related to golf! I'm looking to build on a couple I've seen. We've got a list of guys who play each weekend. Each person can be assigned on a number and each has a handicap from the white tees and blue tees (which can be captured via a separate lookup table).
After entering the ID# of each golfer, I would like to be able to enter which color tees we are playing from and what size teams we want (3 or 4 golfers per team). The latter will be determined by how many golfers we have. If we have 17 golfers, we will only enter 16 ID#'s. The 17th person can join one of the 4 foursomes. I would like the groups (whether that be 3-somes or 4-somes) to have total handicaps (simple summing) as close as possible together, recognizing that only rarely can they all be the same. Most handicaps will be positive numbers, but two or three may be negative (they shoot under par on average). I'm including a file I saw on here from 5 years ago which starts to solve the problem, but I would replace columns C and D on the Player ID and Info tab with handicaps from the white and blue tees. Would also be great if all 40 or so players could be listed and a box in (inserted) column A could be "ticked" with who was playing that day.

I noticed MarvinP and some others were helpful putting the macro in the attached together.

Thank you very much in advance,
Tom

P.S. Oops, did not have luck being able to attach the spreadsheet. Perhaps because I'm using Edge or perhaps operator error! It was a file from the thread "Macro for making golf teams randomly" started by rwhite713 back on 7/25/10.