+ Reply to Thread
Results 1 to 6 of 6

Auto Sort Table

  1. #1
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Auto Sort Table

    Hi,

    I have created a table which is populated from using an index lookup.

    I've created some VB which should auto sort the table based on % but doesnt seem to work.

    Attached is a copy.

    Kind Regards

    Chris
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Auto Sort Table

    I think you have to do all operations by macro without using formulas
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Re: Auto Sort Table

    So could hard code the results and then have the auto sort run?

  4. #4
    Registered User
    Join Date
    03-28-2014
    Location
    Hertford, England
    MS-Off Ver
    Excel 2010,2013
    Posts
    38

    Re: Auto Sort Table

    Hi,

    in K7 put:
    Please Login or Register  to view this content.
    In L7 put:
    Please Login or Register  to view this content.
    If you drag these down the length of the table this should give you a sorted WTD column

    I used this formula to aid in a football league table.

    Hope it helps.

  5. #5
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Re: Auto Sort Table

    Can you explain why the
    Please Login or Register  to view this content.
    uses $c$6?

  6. #6
    Registered User
    Join Date
    03-28-2014
    Location
    Hertford, England
    MS-Off Ver
    Excel 2010,2013
    Posts
    38

    Re: Auto Sort Table

    C6 is a reference point above the site names. The match part looks down the ranking to find out how many rows down from the reference point the formula should look.

    Does that help?

+ 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. Auto Sort Table by Dates
    By Zins517 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 04:21 PM
  2. Auto sort a table with formulas
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2014, 04:58 PM
  3. [SOLVED] Auto sort excel table in VB
    By tryckman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2012, 04:35 PM
  4. Replies: 1
    Last Post: 07-19-2011, 02:53 PM
  5. #REF! on Auto sort table
    By ojstimpy in forum Excel General
    Replies: 3
    Last Post: 03-15-2011, 07:32 PM

Tags for this Thread

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