+ Reply to Thread
Results 1 to 5 of 5

Sort Rows Automatically

  1. #1
    Registered User
    Join Date
    04-28-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    28

    Sort Rows Automatically

    Hello,

    I'm trying to make my worksheet sort automatically, and I was wondering if you can help. Starting row 11 (row 10 is header), rows should be:

    - sorted from A to O
    - sorted by N (Sort Code) column and then by A (Last)

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Sort Rows Automatically

    In Excel 2003, go to Data Menu, then sort.
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    04-28-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Sort Rows Automatically

    No, I mean sort automatically when I enter or change a cell in the "Sort Code" or N column.


  4. #4
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Sort Rows Automatically

    I'm not 100% how to do it when you leave the activecell, but i have added a button which can be clicked by the user (column K) called 'Sort'
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-28-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Sort Rows Automatically

    Perfect, thank you!!!

+ 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