G
Guest
I have worksheets listing score totals for individuals in a tournament. Some
people are in more than one tournament, hence, more than one worksheet.
When I create an +overall" worksheet that links to the separate tournaments,
I can add all the points together for people who are in more than one
tournament, but when I sort the orginal worksheets, it messes up the order in
the "overall" worksheet.
Is there a way to make the linked cells stay where they are out? I have
tried naming cells and making them absolute, but a sort in tournament 1,
moves the "overall" cells in column 2, but not the other cells in that row.
people are in more than one tournament, hence, more than one worksheet.
When I create an +overall" worksheet that links to the separate tournaments,
I can add all the points together for people who are in more than one
tournament, but when I sort the orginal worksheets, it messes up the order in
the "overall" worksheet.
Is there a way to make the linked cells stay where they are out? I have
tried naming cells and making them absolute, but a sort in tournament 1,
moves the "overall" cells in column 2, but not the other cells in that row.