Lookout For Randomizer
Apr 30, 2007I'm creating a fantasy football manager game for a friend, and want help doing the team list and as it all needs to be random, I thought this to be best.
I need to randomize a players name from a first and surname list in Sheet 1, the first names in A1 and surnames in B1 going down to A150/B150, and put them into sheet 2.
On sheet 2, the name would go into A1. I also need it to create a random rating between 30 and 100. This will go in B1.
I need this done for 3 players, so these will go into Rows 1, 2 & 3.
Going in column C would be a players age, which I'd like to randomize between 17 and 30.