Automatic sort by descending order

[anapaulacasseta]

Don't know if macro is better, but I would like to try it with function

I have 2 sheets.

Sheet 1
Column A: Name
Column B: Points

Exemple:
Name Points
Mary 40
Johnny 20
Erick 60
Ralph 30

I want Sheet 2 to get data from Sheet 1 and sort by descending order automatically.

Then it should be

Sheet 2

Name Points
Erick 60
Mary 40
Ralph 30
Johnny 20

I don't want to do it manually every time I change some value; I want it to do automatically; so if I change, for example, Erick's points from 60 to 10 in Sheet 1, Erick should appear on the last place in Sheet 2, with his new value (10)

Thanks, in advance.

[FDibbins]

Hi and welcome to the forum

For the numbers, use this in sheet2 B2, copied down...
=IFERROR(LARGE(Sheet1!$B$2:$B$5,ROW(A1)),"")

Then in sheet2 A2, copied down
=IFERROR(INDEX(Sheet1!$A$2:$A$5,MATCH(Sheet2!B2,Sheet1!$B$2:$B$5,0)),"")

Woud you need to consider duplicate scores?