+ Reply to Thread
Results 1 to 6 of 6

sorting out columns but only for some rows

  1. #1
    Sam
    Guest

    sorting out columns but only for some rows

    Hi,

    I would like to create a macros that will sort out the first 5 rows of
    my spreadsheet only. The reason for that is that in the middle of my
    spreadsheet i have another group of cells that represent a table and I
    don't want that one to be sorted.

    How can i do that ?

    Thx


  2. #2
    Bernie Deitrick
    Guest

    Re: sorting out columns but only for some rows

    Sam,

    Either select just the cells that you want sorted, prior to the sort, or
    insert a new row between the tables to prevent them being sorted together.

    HTH,
    Bernie
    MS Excel MVP


    "Sam" <samuel.berthelot@voila.fr> wrote in message
    news:1114187047.257338.215860@l41g2000cwc.googlegroups.com...
    > Hi,
    >
    > I would like to create a macros that will sort out the first 5 rows of
    > my spreadsheet only. The reason for that is that in the middle of my
    > spreadsheet i have another group of cells that represent a table and I
    > don't want that one to be sorted.
    >
    > How can i do that ?
    >
    > Thx
    >




  3. #3
    JulieD
    Guest

    Re: sorting out columns but only for some rows

    Hi Sam

    something along these lines

    sub sortsome()

    Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes,
    _
    OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

    End sub

    where you have a header row (if not, change Header:=xlYes to Header:=xlNo
    and A2 to A1) and you want to sort on the value in column A, if not, change
    the A to whatever column you want to sort on

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "Sam" <samuel.berthelot@voila.fr> wrote in message
    news:1114187047.257338.215860@l41g2000cwc.googlegroups.com...
    > Hi,
    >
    > I would like to create a macros that will sort out the first 5 rows of
    > my spreadsheet only. The reason for that is that in the middle of my
    > spreadsheet i have another group of cells that represent a table and I
    > don't want that one to be sorted.
    >
    > How can i do that ?
    >
    > Thx
    >




  4. #4
    JulieD
    Guest

    Re: sorting out columns but only for some rows

    oops the _ was supposed to be on the same lines as the xlYes,

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
    news:ufv3Fv1RFHA.3420@TK2MSFTNGP14.phx.gbl...
    > Hi Sam
    >
    > something along these lines
    >
    > sub sortsome()
    >
    > Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes,
    > _
    > OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    >
    > End sub
    >
    > where you have a header row (if not, change Header:=xlYes to Header:=xlNo
    > and A2 to A1) and you want to sort on the value in column A, if not,
    > change the A to whatever column you want to sort on
    >
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ...well i'm working on it anyway
    > "Sam" <samuel.berthelot@voila.fr> wrote in message
    > news:1114187047.257338.215860@l41g2000cwc.googlegroups.com...
    >> Hi,
    >>
    >> I would like to create a macros that will sort out the first 5 rows of
    >> my spreadsheet only. The reason for that is that in the middle of my
    >> spreadsheet i have another group of cells that represent a table and I
    >> don't want that one to be sorted.
    >>
    >> How can i do that ?
    >>
    >> Thx
    >>

    >
    >




  5. #5
    Sam
    Guest

    Re: sorting out columns but only for some rows

    i've done that. but it still modifies the rows below.
    You can find my spreadsheet here:
    http://graphicsxp.no-ip.com/share/Book1.xls
    maybe I haven't been clear enough about what i want to achieve and
    you'll get the visual straight away.

    Thx


  6. #6
    Max
    Guest

    Re: sorting out columns but only for some rows

    The recorded macro below seems to be able to do the job ..
    (Sort by col C - Descending, then by col B - ascending)

    Sub Macro2()
    Sheets("Sheet1").Select
    Rows("1:6").Select
    Selection.sort Key1:=Range("C2"), Order1:=xlDescending,
    Key2:=Range("B2") _
    , Order2:=xlAscending, Header:=xlYes, OrderCustom:=1,
    MatchCase:=False _
    , Orientation:=xlTopToBottom
    Range("A1").Select
    End Sub

    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Sam" <samuel.berthelot@voila.fr> wrote in message
    news:1114261263.712388.109520@o13g2000cwo.googlegroups.com...
    > i've done that. but it still modifies the rows below.
    > You can find my spreadsheet here:
    > http://graphicsxp.no-ip.com/share/Book1.xls
    > maybe I haven't been clear enough about what i want to achieve and
    > you'll get the visual straight away.
    >
    > Thx
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1