Help automatic sorting colums A, B by number values in Column B (when data refreshes)

**andrewmcdonald21** · 06-17-2011, 02:30 PM

I have a spreadsheet set up for the golf tournament this weekend.

I've got a leaderboard with the participants names in Column A and their respective scores in Column B. I'd like to have the board automatically sort from low-to-high based on scores. (The data for scores is linked to a webpage and refreshes every minute.)
How do I go about doing this?
Any help is greatly appreciated.

I've attached the file. It's the "Leaderboard" on Sheet 1 in columns A and B.

**olga6542** · 06-17-2011, 02:48 PM

Select cells from A5 to B20. Click on Data---> Sort. Make sure you sort by teh score in the ascending order.

**andrewmcdonald21** · 06-17-2011, 03:00 PM

Thanks for the help. The scores sort properly when I do that.

BUT when scores update and change, they stay in their same cells. They don't automatically adjust up and down.

Is there anyway I can get the scores (along with their respective players) to move up and down the leaderboard as the scores refresh/adjust??