Hi, im trying to set up a sheet that will allow me to run a succession of
tournaments and create a rankings table automatically.

Each week we will have a tournament and each week we may not have the same
people attending. I have a list which i will put into excel of all the
people who could possibly turn up.

Basically, what i want this sheet to do, is to assign the people who turn up
on a given week a random position in the fixture sheet for the tournament.
It has to be random so they dont end up drawing the same person each week.

Put simply and out of context, I want to be able to assign a specific number
of cells from a list, into another list of cells in a random order.

Is this possible.