I'm trying to set up a spreadsheet that I can use to keep track of wins and losses between two people, the entire roster is repeated on the vertical and horizontal header. I have a VB function that will keep my list of contenders on columnA in real-time alphabetical order as I add more contenders, and the row1 header contains simple Offset() functions to mirror what's in columnA.

Now, the actual data (number of wins) pairs fine with the columnA changes (if a new contender gets entered, the number of wins for the contenders will pair correctly), but it doesn't stay paired for row1. How can I make it so that the data pairs with both columnA and row1 changes?

Let me know if you need more of a description! Thanks!