Auto sort after adding new figures

**skittler** · 08-11-2013, 01:37 PM

I compile results tables for a local sports league.
I have formula to give total games played and total number of points gained.
Is there anyway I can get the table to automatically sort as I enter data?

I am using excel 97-2003

Table columns are; (A) Name of team, (B) Games played, (C) Games won (2pts each), (D) Games Drawn (1pt each), E Games Lost (0pts), (F) Legs Won (1pt each) (G) Total number of points,

14 teams in each table.

As I enter data into C,D, E and F A and G will total but I would like whole table to sort with highest total of G on top.

Can it be done?

**RobertMika** · 08-11-2013, 04:10 PM

Could you upload your workbook?
With desired outcome(s)?

**skittler** · 08-11-2013, 05:12 PM

Originally Posted by RobertMika

Could you upload your workbook?
With desired outcome(s)?

Table 04-02-13.xls

Hope this is what you mean

If you change figures in Column headed W and Legs, Column headed Pts will update.
I want all table to auto sort to give Pts column totals descending.