Reshuffle group combinations without repitition...

I've been working on something similar, a bowling schedule generator. It's almost impossible for a spreadsheet, as far as i can tell.

Macros are needed to really get close and its still hard. For golf it might be a little easier, because you don have to worry about moving to different lanes every week.

But here's a place you can start this formula works ok for a small group. you should be able to change it maybe.

Some search terms are Round robin, Fixtures, fixtures list, League tables, team schedules also there are some free sites that will make them.

16 team/players

...cell.A..............................cell......B
...Week.....................................1
=IF(B1+1<16,B1+1,1)...............=IF(B3+1<16,B3+1,1)
=IF(A2+1<16,A2+1,1)...............=IF(B4+1<16,B4+1,1)
=IF(A3+1<16,A3+1,1)...............=IF(B5+1<16,B5+1,1)
=IF(A4+1<16,A4+1,1)...............=IF(B6+1<16,B6+1,1)
=IF(A5+1<16,A5+1,1)...............=IF(B7+1<16,B7+1,1)
=IF(A6+1<16,A6+1,1)...............=IF(B8+1<16,B8+1,1)
=IF(A7+1<16,A7+1,1)...............=IF(A8+1<16,A8+1,1)
Team off.....................................=B1

Some info places
FixtureListGenerator Info

Round Robin Tournament Scheduling

Golf League Schedule Templates

This is an individual movement from duplicate bridge -- maybe it can be adapted to 16 rounds for 24 players.

      -A- B- -C- -D- E F- -G- -H- I- J -K- -L- -M- -N- O -P- Q- -R- -S-
  1   16  1   6  10    4   5  13  3     8  15  12   9     7  2  11  14 
  2   16  2   7  11    5   6  13  4     9  15   1  10     8  3  12  14 
  3   16  3   8  12    6   7  13  5    10  15   2  11     9  4   1  14 
  4   16  4   9   1    7   8  13  6    11  15   3  12    10  5   2  14 
  5   16  5  10   2    8   9  13  7    12  15   4   1    11  6   3  14 
  6   16  6  11   3    9  10  13  8     1  15   5   2    12  7   4  14

As spreadcore says, this is, in general, a very hard problem.

Heres a quick try for you to see if this is close to what your looking for.

Its 24 players divided into 6 groups of 4 players each week for 20 weeks. Using a variation of the above formulas.