Sort Largest to smallest automatically

Hi there
I have a spreadsheet where I would like to sort largest to smallest automatically as the numbers are updated. Column A is the name and Column B the number.
Could anyone help?
Example attached
Kind regards
John

Hi there
Thanks - i have tried to type the code in to the VBA editor using:
On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
On the Insert menu, click Module.
Type or copy your code into the code window of the module.
If you want to run the macro from the module window, press F5.
When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.
but when I try to run the macro it can't be found.
Please forgive my ignorance
Cheers
John

Hi
I get the following - I'm obviously still doing something wrong
Cheers
John