sorting rows based on value

[jimn999]

I want to do a spreadsheet for all the races in the grand prix.
There will be a list of racers against a list of race tracks.

As each race is complete the points they receive will be entered int
the corresponding cell. Then the total for all races will be entered a
a sum at the end of each row.

What I need is for the rows to be sorted based on the points total o
each driver - hence making a leaderboard.

How would I do this

 

[Frank Kabel]

Hi
not quite sure but maybe 'Data - Sort' is what you're looking for

 

[Bob Phillips]

Jim,

Just make sure that you select all of the columns, and you specify the total
column in the sort key.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[jimn999]

Thanks guys,

I was hoping for something a little more automatic then that but at th
end of the day it would probably make it over-complicated anyway.

Thanks

Jame

 

[Dave Peterson]

Maybe you could record a macro when you do it once. Then run it whenever you
needed to sort.

If you have trouble tweaking your recorded code, post back.

 

[jimn999]

...i dont know how to record macros???

 

[Frank Kabel]

Hi
goto 'Tools - Macros - Record Macro'. Also have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm

for getting started with macros

 

[jimn999]

cool, thats very straight forward!!

Thanks for your help

Jame