SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello all,
I have a list of names, two of whom need to call each other each week. This needs to randomly shuffle on a weekly basis and no two names must match or be the same ones calling each other. I am halfway there, but am still getting two names matched and the same ones calling each other when using F9 to shuffle. The second part of my query is I wondered if there is a VBA that can be used with a macro button instead of using F9?
Ta muchly, folks!
Sara
I have a list of names, two of whom need to call each other each week. This needs to randomly shuffle on a weekly basis and no two names must match or be the same ones calling each other. I am halfway there, but am still getting two names matched and the same ones calling each other when using F9 to shuffle. The second part of my query is I wondered if there is a VBA that can be used with a macro button instead of using F9?
Stay connected template.xlsx | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
2 | Name | calls | Name | ||||
3 | Paul Jones | 0.1 | Jane Doe | ||||
4 | John Smith | 0.8 | Paul Jones | ||||
5 | Tracy Waters | 0.3 | Sandra Grass | ||||
6 | Sandra Grass | 0.2 | John Doe | ||||
7 | John Doe | 0.5 | John Smith | ||||
8 | Jane Doe | 0.3 | Tracy Waters | ||||
Call Register (2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3:C8 | C3 | =RAND() |
D3:D8 | D3 | =INDEX($B$3:$B$8,RANK(C3,$C$3:C$8,),1) |
Ta muchly, folks!
Sara