+ Reply to Thread
Results 1 to 2 of 2

Auto Sort results

  1. #1
    Registered User
    Join Date
    10-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    34

    Auto Sort results

    Hi, I'm trying to do an auto sort whenever shortlisted admin worksheet is updated. When updates are made to Cell B, Cell Z will sort by descending.

    But the following macro does not sort the list whenever new data are added to cell B. Following are the codes, i not sure where i did wrong.

    B11:Z11 is the header

    I have added this piece of macro to the worksheet(Shortlisted Admin) that needs to be sorted.

    Please Login or Register  to view this content.
    Is it possible to display first 6 results after sorting. Any help would be appreciated.
    Attached Files Attached Files
    Last edited by ChalkerL; 11-22-2009 at 10:50 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,345

    Re: Auto Sort results

    Your profile says you are using XL'03, but you supplied an XL'07 workbook.

    I am not sure about XL'07, but I do know in XL'03, that sorting formulas will never get you the desired results hoped for, because sorting does not rearrange the cells, it rearranges the data in the cells.

    You may have to look into autofilter.

+ 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