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?