Looking for a freeware that can put numbers in numerical order

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HERACLES
    New Member
    • Jul 2010
    • 1

    Looking for a freeware that can put numbers in numerical order

    I Looking for a freeware that can put numbers in numerical order? I could use excel but It make this for 3 lines each time, if I'd do in this way I'll take ad aeternum to finish the work. Is it avaliable a freeware, spreedsheet/vb/vba that do all the work at once??
    I´d like to put large numbers sequence in ascending order(from the smallest to the greatest number) (from the left-to-right direction) for each sequence number line
    I put an attachment as an example of large numbers list in order to try doing this
    Cans someone could help me ???

    Thanks in advance
    Attached Files
    Last edited by HERACLES; Jul 15 '10, 07:26 PM. Reason: CORRECT
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    Tutorial with examples http://www.vb6.us/tutorials/understa...basic-tutorial

    Comment

    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429

      #3
      Please let us know how this works out for you. At a glance, the linked tutorial looks like a very useful one.

      Comment

      • Guido Geurs
        Recognized Expert Contributor
        • Oct 2009
        • 767

        #4
        This macro will sort each row ascending (see also attachment)

        Code:
        Sub Sort_Numbers()
           Range("A1").Activate
           Do While ActiveCell.Value <> ""
              Range(ActiveCell, ActiveCell.End(xlToRight)).Select
              Selection.Sort Key1:=ActiveCell, Order1:=xlAscending, Header:=xlGuess, _
                 OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _
                 DataOption1:=xlSortNormal
              ActiveCell.Offset(1, 0).Activate
           Loop
        End Sub
        Attached Files

        Comment

        Working...