Auto sort scores

[Number_8]

I am running a charity quiz where there will be 40 tables competing for prizes. There will be 10 rounds and 1 bonus round, there is a tab for each, where we can enter the scores they get for each round. The scores will be shown on a screen and therefore need to be laid out landscape (resulst sheet) as they are rather than on one long list.

As the scores are entered, I want the results sheet to re-sort itself by the team with the highest score at the top and the related team name listed next to it.

Can you help?

[martindwilson]

probably but as you havent even acknowledged the reply i gave on your similar post
http://www.excelforum.com/showthread.php?t=630554
dont see why anyone could be bothered!
ah ha i see your reply now. sorry to be rude but it does help if its acknowledged even if its wrong or you want to do something a bit more as in this case
anyway this version has a macro that will auto sortbut you still need to click on the tab "team name and for sort for it to do its calculation.
macro from here http://www.mrexcel.com/archive/VBA/14079.html