I am trying to work out a competition schdule using excel

I could have any where from 10 to 14 Players and the spreadsheet will be set
up as follows

Column A will be the player numbers (10 to 14) and column B will also be 10
to 14

is there any way to code it so that it can produce a schedule where each
player plays every other player once and if I adjust he number (ie only 12
players) I can recaculate the schedule

thanks