Hi,
I've created this table as an example.
What I would like to do is get this table to automatically sort the players in order as scores are entered on another sheet. The formulas in the table are already set to update automatically with the wins, losses, points etc. But I always need to press to sort out after these scores are entered rather than it just sorting on it's own.
So what I would like is a way that the table automatically puts whoever has the highest "Points" at the top followed by the highest "Diff". At the moment this is just done with a custom sort after each score is entered.
Appreciate any help.
Kind regards,
Andy
I've created this table as an example.
What I would like to do is get this table to automatically sort the players in order as scores are entered on another sheet. The formulas in the table are already set to update automatically with the wins, losses, points etc. But I always need to press to sort out after these scores are entered rather than it just sorting on it's own.
So what I would like is a way that the table automatically puts whoever has the highest "Points" at the top followed by the highest "Diff". At the moment this is just done with a custom sort after each score is entered.
Appreciate any help.
Kind regards,
Andy