+ Reply to Thread
Results 1 to 3 of 3

Automatic sorting

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Manchester, England
    MS-Off Ver
    MS 365
    Posts
    52

    Automatic sorting

    This is probably quite easy but I can't find a very descriptive explanation on how it works.
    I have a list of data covering 12 Columns, A:L, and 28 Rows including the Header Row.
    Row L is a totals Column and I want the entire range to sort automatically Highest to Lowest based on the totals in Column L. (Obviously keeping the row data together)
    Also the data range I want sorting is populated using formulas relating to other worksheets so there is no actual typing going into that worksheet.
    I have seen some stuff online that talks about having code in the worksheet but it isn't that easy to follow if your range covers more than 2 columns.
    All help gratefully received.
    Last edited by chris.slater; 10-02-2013 at 06:38 AM.

  2. #2
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Automatic sorting

    I think i know what you want , but let's be honest how many people are going to understand this without an example workbook.

    Basically a lot of us are going to recognize what you want as the soccer spread sheets where the league table is auto updated each time a score is added for a game.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  3. #3
    Registered User
    Join Date
    03-12-2012
    Location
    Manchester, England
    MS-Off Ver
    MS 365
    Posts
    52

    Re: Automatic sorting

    That's essentially it.
    The attached is a copy of the totals page. The original is updated via links to totals on other pages but the requirement is the same.
    I want it to auto sort based on the Total Score in Column L so that when I enter a value in one of the other pages the list on the totals page is automatically sorted by order of Highest Score to Lowest Score.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic Sorting
    By buddy123 in forum Excel General
    Replies: 3
    Last Post: 09-05-2012, 09:18 AM
  2. [SOLVED] Need help on automatic sorting
    By akalien in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 07:44 AM
  3. Automatic Sorting
    By SumTuck in forum Excel General
    Replies: 3
    Last Post: 06-22-2012, 06:58 PM
  4. Automatic Sorting,
    By adambaumil in forum Excel General
    Replies: 2
    Last Post: 11-14-2008, 03:17 PM
  5. Automatic Sorting?????
    By Bigredno8 in forum Excel General
    Replies: 3
    Last Post: 05-28-2005, 06:11 PM

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