Newbie here
I have a speadsheet for sport results
The first 20 tab are the player and we list the score of that player. Each column is the skill they performed. Each line is the matches in the season
the next 25 tabs are all the matches for the season. each line is a player, nd each column is a score for a specific skill
In the player 1 tab, I then referenced Match1:B3 then Match1:C3 etc etc
I want to create tab for player 2 -> 20, when I paste the content of tab 1 into tab2, I end up with match1:b3 and match2:c3, but I would like to get Match1:b4 and match2:c4 (because the 4th line in each match tab is the info about player 2)
I attached a spreadsheet to show the issue
thank you for any pointers you may have (doc, forum post (couldn't find a match) or article)
Chris
Bookmarks