Help making league table with MS excel?

Question

I have made a league table with the formula's for points and goal difference. What i need to know is how to sort the positions of the teams with the most at the top automatically when you enter the data.

Answer 1

I know a button that will do this, but I'm not sure if you activated if it'll do it automatically.

In the same toolbar as the "New Sheet" "Save" and "Open" etc, there's two buttons like this:

A↓  and  Z

Z.........A↑

They order text and numbers in either ascending or descending order, just be sure to select all the rows that need to be sorted, not just the colom.  

Answer 2

Here's the solution to your problem

http://www.freewebs.com/swhtam/YA/sortSc...

Alt+F11 and double click on the sheet1(sheet1) icon on the left of the vba editor, then you will see the code that make things happen, if you want to use the code copy it to your sheet module, and change the first 2 lines of the code to suit the ranges of your input range and the table sort range.

Please contact for more info

Answer 3

Highlight the range of your league table, include all the columns in the highlighted range.  Then menu Data > Sort and set the order of the sorting is to take place.  Your first column of sorting will the whatever column of data you want to control the order of the sort.

This will not do an automatic sort after the entry of any new data.  It will maintain the range of data but you will have to execute the sort to cause it to re-order you standings.  If additional columns are thought to be necessary, include those columns in the initial range OR make the range one column wider than necessary and insert columns within the range.  The range will then expand automatically with the added column included.  Regarding the automatic resorting, that would not really be desirable as the list would change with every entry making the entry of data difficult.