I've been looking everywhere to try and find a way to create a macro/vba thing to help me with a worksheet im currently completing.
I imagine it/need for it to randomly choose two names from the COMPETITORS tab and place one name in column B and one name in column I of the MATCHES tab on the same line and go down to the latest line available (as represented by the game/column a) without repeating a name.
Provided that its not that much effort to add additional requests, i would need it to do additional things as a seperate option.
-Only choose two names randomly that appear in the same "Class" as per column K in COMPETITORS tab
-Allow names to be repeated
Any help or suggestions would be gratefully appreciated