Hi, sorry to bother you but I need your help. This is what I have. http://www.excelforum.com/excel-gene...auto-sort.html Here is your post. http://www.excelforum.com/excel-2007...o-sorting.html Basically, I want to input information in " Player DATA " sheet only and lock the other ones. I've succeeded in doing so, everything works fine, every player's personal page are updated; points, percentage, ranking and so forth, I even made it so that even the names are linked to the Player DATA sheet so I can add, change or replace names all within one place. The only problem is in the " Fax " page, all the information is linked, players, points and rank is calculated. What I need is for the table to sort, based on the value of column " C " in numerical order in a descending fashion, ( Highest on top and lowest at the bottom ). It does not really have to be done in real time, when I switch page would be real great. Thanks in advance, Mike.
