In ranking order ?

fireslguk

Active Member
Joined
Nov 11, 2005
Messages
281
Hi folks,

another query for any1 to suss 4 me :confused:

I have 1 column with text descriptions e.g types of vehicles
I have a second col with numbers

I would like the 2 areas to adjust themselves automatically with the highest no at the top and relevant vehicle type next to it in running order and lowest no at the bottom.

thanks in advance :)
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

fireslguk

Active Member
Joined
Nov 11, 2005
Messages
281
the following is ok but i want it to happen on opening the file



Sub Macro1()
'
' Macro1 Macro
' Macro recorded 15/11/2005
'

'
Range("B4:C6").Select
Selection.Sort Key1:=Range("C4"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,540
Messages
5,572,791
Members
412,484
Latest member
deezina07
Top