Hi there,
I'm creating an excel sheet to keep track of wins/losses in a tournament and update scores. Each player starts with a rank (value). Player ID, name and rank are in Col A:C.
What I want to happen is that for each round, the player IDs (two opponents) are entered into Cell range F2 and G2, whether they win or lose is recorded in F3 and G3, and each player's new ranking value is calculated in F4 and G4. (See attached sheet)
What I'd like is to run a macro at the end of each round so that:
- The round number is updated in Col I
- The Player ID# and their win/loss for that round to be appended in Col J:M
- And each player's score is updated at the end of each round in Col C.
I've tried a few different things, but nothing seems to work cleanly and neatly. Your help would be appreciated!
Bookmarks