+ Reply to Thread
Results 1 to 5 of 5

Custom Sort Macro - Update on Data Entry

Hybrid View

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    Long Island
    MS-Off Ver
    Excel 2007
    Posts
    4

    Custom Sort Macro - Update on Data Entry

    So my friends and I have a lot of time this summer, and we plan on playing out a mock world cup on FIFA 2010. I created the attached rudimentary spreadsheet that can keep track of stats and standings and stuff like that. I am looking for a way to automatically sort the standings (on the Group Tables sheet) as I enter scores into the Group Stage schedule on the Group Stage sheet (the long skinny table on the left). The intent is to sort each group first by PTS, then GD, then GF, and finally GA column. However, I'm not great with the programming so I was hoping someone can give me a hand. Is this possible to do? Or will the ongoing sorting function mess with the relative cell formulas?

    Another issue I'm having recently is using the custom sort function. I tried to sort Group A using the custom sort of first PTS, then GD, then GF, and GA using a custom sort. But when I hit sort, the results aren't even close to what they should be, and they keep changing even though I'm applying the same sort over and over again. Give it a shot and see if you understand my issue.

    Thanks for anybody who can help me out on this ridiculously irrelevant project I have saddled myself with.
    Attached Files Attached Files
    Last edited by cuso524; 07-21-2010 at 11:47 AM.

  2. #2
    Registered User
    Join Date
    07-20-2010
    Location
    Long Island
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom Sort Macro - Update on Data Entry

    OK timeout. This would be easier if I posted the right file. please disregard the attachment above while I find the correct one.

  3. #3
    Registered User
    Join Date
    07-20-2010
    Location
    Long Island
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom Sort Macro - Update on Data Entry

    Ok, now we're good. Thanks again.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Custom Sort Macro - Update on Data Entry

    Does that mean you've changed the file?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    07-20-2010
    Location
    Long Island
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom Sort Macro - Update on Data Entry

    Yes sir, the correct file has been uploaded to the first post.

+ 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