Randomly Pair Names in a list

**Gos-C** · 10-26-2006, 01:01 PM

Hi,

I have a spreadsheet with a list of names, such as:

Abc
Def
Ghi
Jkl
Mno
Pqr
Stu
Vwx
Yza
Bcd
Efg
Hij
Klm
Nop
Qrs

The spreadsheet would be shared, and should show one pair each day whenever it is opened. A name should not be repeated until all the other names have been used, and after all the names have been used, the names should be randomly paired again for the next cycle.

Can someone write a code to do this for me, please.

Thank you kindly,
Gos-C

**theDude** · 10-29-2006, 07:21 AM

Hi Gos-C!

I'm not sure I fully understand your requirements yet, so please indulge me while I try to get a grasp on your requirements.

As I understand it so far, when a user opens the file, only two randomly selected names from the one-column list should appear; but you don't specify how they should appear, i.e. in a new worksheet in the file; in a user form, in a new workbook, etc....

You also don't specify what happens after the randomly selected pairing is made.

Since the file is shared, it seems that the first person to open it will set the pairing for that day and everyone else will only view what pairing was set???

Will the list of names increase/decrease over time? If so, will it occur in the middle of a 'cycle'? If it does, what are the rules for finishing the current 'cycle'?

theDude