Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Update and Auto Sort the Second sheet from the First Sheet

    Hi there, Please find attached and help me with the attached. PLEASE READ THE NOTES FIRST TO GET AN UNDERSTANDING OF WHAT I AM TRYING TO ACHIVE. If you do not want to read it this is a brief summary of what I am trying to achieve. I am trying to create a situation where I have a Quiz Scoresheet done out. In the ORIGINAL sheet tab I have done out a scoresheet. In the SORTED & AUTOUPDATED sheet tab is where I want all the calculations, sorting from ZtoA, auto update, formulas, vba and refresh all so that in the OVERALL SCOREBOARD will give the Position, Table No. and Scoring i.e. what position tables are coming in. Also, that you can add or subtract how many rounds you want to do. If you can solve this could you please send your solution and a step to step guide on what and how you did to achieve of what I am trying to achieve to tictockky@gmail.com. Please type in the subject header "Quiz Scoresheet".

    Quiz Scoresheet.xlsx
    Last edited by Mr IT Stuck; 2015-12-07 at 15:49.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    IT Stuck,

    I've moved your post to a new thread. Please do not hijack other lounger's posts.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    It is much better to have responses showing in this forum, where everyone can see and benefit from them, than having them sent privately.

    Also, putting your email address in your posting is an invitation to spammers. I would advise editing it out of your post.

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    In the SORTED & AUTOUPDATED sheet tab is where I want all the calculations, sorting from ZtoA, auto update, formulas, vba and refresh all so that in the OVERALL SCOREBOARD will give the Position, Table No. and Scoring i.e. what position tables are coming in
    Mr IT Stuck,

    Your explanation is not clear as to the formulas, vba, and sort ranges you are using to achieve what purpose. Perhaps you can explain what the SORTED & AUTOUPDATED sheet is supposed to do. An overview of how you envision the workbook to function would be helpful.

    BTW, to expand on Martin's concern, for us to send you the solution via email would also expose our email address as well.

    Maud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •