+ Reply to Thread
Results 1 to 5 of 5

Automatic League Sort

  1. #1
    Registered User
    Join Date
    04-14-2006
    Posts
    16

    Unhappy Automatic League Sort

    Hi

    I have a league table (attachment table named 'World Cup League'). It updates scores as i enter them into a data table that precedes it (titled 'Games Won'). I would like to be able to automatically sort the 'World Cup League' in descending order every time i enter data into the 'Games Won' table to save me having to sort it every time. Any ideas would be gratefully received as i am trying to run a competition as a charity event and need to have to do as little possible to save time. Thank you
    Attached Files Attached Files
    Last edited by Blade2304; 05-17-2006 at 04:47 PM. Reason: Forgot attachment

  2. #2
    Gary
    Guest

    Re: Automatic League Sort

    You can do it everytime you open the workbook.

    Private Sub Workbook_Open()
    'your code here
    End Sub

    Thats all I know.
    Gary
    "Blade2304" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi
    >
    > I have a league table (attachment table named 'World Cup League'). It
    > updates scores as i enter them into a data table that precedes it
    > (titled 'Games Won'). I would like to be able to automatically sort
    > the 'World Cup League' in descending order every time i enter data into
    > the 'Games Won' table to save me having to sort it every time. Any
    > ideas would be gratefully received as i am trying to run a competition
    > as a charity event and need to have to do as little possible to save
    > time. Thank you
    >
    >
    > +-------------------------------------------------------------------+
    > |Filename: World Cup.zip |
    > |Download: http://www.excelforum.com/attachment.php?postid=4776 |
    > +-------------------------------------------------------------------+
    >
    > --
    > Blade2304
    > ------------------------------------------------------------------------
    > Blade2304's Profile:
    > http://www.excelforum.com/member.php...o&userid=33492
    > View this thread: http://www.excelforum.com/showthread...hreadid=543078
    >




  3. #3
    Otto Moehrbach
    Guest

    Re: Automatic League Sort

    For Excel to "automatically" do anything (such as sort), there must be
    something to trigger Excel to sort. This can be something like entering
    anything in a cell in Column whatever, or Row whatever, or in a specific
    cell. You said "every time I enter data into the 'Games Won' table". Do
    you mean whenever you enter anything in any cell in the entire table? Or
    maybe you mean whenever you fill in a row. In that case Excel can be setup
    to sort when you enter something in the last cell of a row. In other words,
    when you enter anything into any cell in that column.
    Or perhaps you would like to have just a button somewhere in the sheet,
    usually at the top, that you can click on to trigger the sort. Post back
    and clarify what you have and what you want. HTH Otto
    "Blade2304" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi
    >
    > I have a league table (attachment table named 'World Cup League'). It
    > updates scores as i enter them into a data table that precedes it
    > (titled 'Games Won'). I would like to be able to automatically sort
    > the 'World Cup League' in descending order every time i enter data into
    > the 'Games Won' table to save me having to sort it every time. Any
    > ideas would be gratefully received as i am trying to run a competition
    > as a charity event and need to have to do as little possible to save
    > time. Thank you
    >
    >
    > +-------------------------------------------------------------------+
    > |Filename: World Cup.zip |
    > |Download: http://www.excelforum.com/attachment.php?postid=4776 |
    > +-------------------------------------------------------------------+
    >
    > --
    > Blade2304
    > ------------------------------------------------------------------------
    > Blade2304's Profile:
    > http://www.excelforum.com/member.php...o&userid=33492
    > View this thread: http://www.excelforum.com/showthread...hreadid=543078
    >




  4. #4
    Registered User
    Join Date
    04-14-2006
    Posts
    16
    Whenever i enter something into the 'Games Won' table. By entering a number into this table in any cell totals change. These totals then transfer into the 'World Cup League' table and therefore the competitors need sorting into rank order with most points first. I know i could do this with manually sorting each time i enter new data but it would be nice if it did it automatically. Also there may be blank rows in this table so i dont want them to be included in this sort.

  5. #5
    Otto Moehrbach
    Guest

    Re: Automatic League Sort

    Blade
    This macro does what you want. I assumed the following:
    Both the Games Won and World Cup League tables are on the same sheet.
    The range of the Games Won table is named GamesWon.
    The range of the World Cup League table is named WorldCupLeague.
    The World Cup League table has its headers in Row 1 and the Rank Order
    column is Column H.
    Note that this is a sheet event macro and must be placed in the sheet module
    of the sheet that holds the two tables. To access that module, right-click
    on the sheet tab of that sheet, select View Code and paste this macro into
    that module. Click on the "X" in the top right corner to return to the
    sheet. Post back if you need help with changing this macro to work with
    your data layout. HTH Otto
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Value = "" Then Exit Sub
    If Not Intersect(Target, Range("GamesWon")) Is Nothing Then _
    Range("WorldCupLeague").Sort Key1:=Range("H2"), _
    Order1:=xlDescending, Header:=xlGuess, _
    OrderCustom:=1, MatchCase:=False, _
    Orientation:=xlTopToBottom
    End Sub
    "Blade2304" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Whenever i enter something into the 'Games Won' table. By entering a
    > number into this table in any cell totals change. These totals then
    > transfer into the 'World Cup League' table and therefore the
    > competitors need sorting into rank order with most points first. I
    > know i could do this with manually sorting each time i enter new data
    > but it would be nice if it did it automatically. Also there may be
    > blank rows in this table so i dont want them to be included in this
    > sort.
    >
    >
    > --
    > Blade2304
    > ------------------------------------------------------------------------
    > Blade2304's Profile:
    > http://www.excelforum.com/member.php...o&userid=33492
    > View this thread: http://www.excelforum.com/showthread...hreadid=543078
    >




+ 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