Automatically sort cells in one sheet based on values in another

Hi,

I am using excel 2013. I have a macro enabled spreadsheet. I have in sheet 1(Picks) - a list of names (columns) and list of teams (rows). For each team win, I add a 'Win' in one column and it automatically (formula used) calculates the points for each of the names. I then link all these names & points to sheet 2 (Ranking Sorted) using as an eg. "=SUM(Picks!V4)" to get the value from 'Picks' - sheet 1.

what I want to do is to automatically sort the columns in "ranking Sorted' - sheet 2. I have three columns in this sheet - "Name, Points, Rankings". I have 28 rows including the header. I wish to sort by 'Rankings', whenever there is a change in any value in sheet 1 (Picks).

thanks,

If i get you right rankings is a Number ? If thats the case then you just go to the Data Tab and click on sorting, this should do the deal if they are just numbers. Try this makro hopefully its working. I'm still not the best in excel.

Sorting_sheet
On Error Resume Next
Range("A1").Sort Key1:=Range("A2"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub

Thanks Joel. I tried it but it does not seem to work. After entering the macro, is there anything else I need to do in the visual basic window ... do I have to run it or do something to trigger it?

The rankings is a number that I have linked from a cell in another sheet.

The manual sorting ie. going to the data tab / sort works fine - I am hoping though to have it sorted automatically.

Thanks again.