Posts by jman41

    Hi,


    Basically i want it to randomly choose two names and place one each in column B and one in column I within the same row


    I want to try and have 3 options for the above: One where no names get repeated, one where names can be repeated but not required, and one where only names within the same "category" can be chosen


    The amount of rows/"matches" havent been determined yet but would essentially be in the hundreds due to the various combinations that would be available

    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


    Comp.xlsx