randomly create schedule for 10 teams

hello, what i need help with at the moment is randomly creating a schedule of sorts for 10 teams to play 2 games each (one home game and one away game). id like a macro to randomly decide who will play who. im not really sure where to start for this

thanks to anyone who was any ideas

Hi,

I'm not sure this is the whole answer but can be a start. Create a column of random numbers next to your team names and then sort the randoms from small to large and it will sort the teams also.