How can I sort a group of numbers

[Jack-P-Winner]

Is there a way to sort a group of numbers starting with the list say in row 10 and I want to move it to row 1. What's in row 9 to row 2, what's in row 8 put it in row 8 and so on

 

[Luke M]

1. Select A4:F15
2. Go to Data - Sort.
3. Uncheck box for "My data has headers"
4. Use dropdowns to Sort by: column A, On: Values, Order: Oldest to Newest
5. Hit ok, and you're done.

 

[Jack-P-Winner]

I Luke, My box is already unchecked and I do not have an option for oldest to newest. Only small to large and large to small. Can it be done by code? OR am I missing something? I am using 2013 but have access to 97 and 2010 if I need to switch computers.

Thanks

 

[SirJB7]

@Jack-P-Winner
Hi!
Tried yet moving from Visicalc to Simphony?
Regards!

 

[Jack-P-Winner]

Hmmm I'm not familiar with those but will check them out. Thanks .... I think lol

 

[Luke M]

Hi Jack,

Running this macro on the exact workbook you gave me produced the desired results.

Sub RunSort()
    With ActiveWorkbook.Worksheets("Sheet1").Sort
        .SortFields.Clear
        .SortFields.Add Key:=Range("A4:A15") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        .SetRange Range("A4:F15")
        .Header = xlNo
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

 

[Jack-P-Winner]

Hey Luke, first and foremost THANK YOU!! How do I go about setting this up to run? Which rows and columns do I start with and do I need to add a button to get it to run?

Thanks

 

[Luke M]

Hi Jack,

Not exactly sure what you are asking. The code I posted is for the sample book you gave me. You can run it from the VBE, or from XL from the Macro menu, or press Alt+F8 to get the Run dialogue, or insert any shape/button and assign the macro to it.

If you want to change the range, you'll notice there are only 2 range callouts. The first is the key field (which column are we sorting), and the 2nd is the entire range of data to sort.