hi, i'm trying to create a football league table for my own use. what i wanna sort is the cell containing points, when ever the cell's value changed it will automatically sort in by largest number to smallest number. pls help me with this...?
how to make auto sort in excel?
- Thread starter adanoob
- Start date
ESA Informatics
New member
- Local time
- Today, 06:42
- Joined
- Nov 3, 2009
- Messages
- 2
The simplest thing would be is to record a marco and run the macro via a command button. So that when the table is updated you run the macro and it sorts out the league positions of the football teams.
ps remember using a simple sort largest number to smallest number might not give you the results you want. For example what if two teams are equal on points, then if you want to factor in goal difference or most games won.
ps remember using a simple sort largest number to smallest number might not give you the results you want. For example what if two teams are equal on points, then if you want to factor in goal difference or most games won.
Last edited:
i'm sry i dunno how to put marco to it... if i attach the file there could u pls help me out with that? if possible i wish the cell (RANK) could remind same, it wont change the value inside when the sorting is done?
ESA Informatics
New member
- Local time
- Today, 06:42
- Joined
- Nov 3, 2009
- Messages
- 2
here you go, I have created a command button based on Rank and Points.
If you do a simple search within excel it will show you how you can record a simple macro. You dont have to have any programming skills, and can be useful to automate tasks.
If you do a simple search within excel it will show you how you can record a simple macro. You dont have to have any programming skills, and can be useful to automate tasks.
Similar threads
