+ Reply to Thread
Results 1 to 2 of 2

Macro to update scores for a tournament

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Macro to update scores for a tournament

    Hi there,

    I'm creating an excel sheet to keep track of wins/losses in a tournament and update scores. Each player starts with a rank (value). Player ID, name and rank are in Col A:C.

    What I want to happen is that for each round, the player IDs (two opponents) are entered into Cell range F2 and G2, whether they win or lose is recorded in F3 and G3, and each player's new ranking value is calculated in F4 and G4. (See attached sheet)

    What I'd like is to run a macro at the end of each round so that:
    - The round number is updated in Col I
    - The Player ID# and their win/loss for that round to be appended in Col J:M
    - And each player's score is updated at the end of each round in Col C.

    I've tried a few different things, but nothing seems to work cleanly and neatly. Your help would be appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Macro to update scores for a tournament

    Just a thought...

    You might explore excel userforms. It sounds like a good application.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ 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. Replies: 1
    Last Post: 06-15-2013, 09:02 PM
  2. [SOLVED] List the most recent five scores from among multiple scores
    By Winship in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2012, 09:25 PM
  3. Macro to update tournament standings
    By jakevr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 11:56 PM
  4. VB macro for sorting through scores and copying certain scores to new sheet
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 01:47 AM
  5. Macro for Golf Tournament not working
    By Woolnerpma in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2005, 06:47 PM

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