Results 1 to 27 of 27

Golf Group Tracking Bet Wins w/ Running totals by Golfer

Threaded View

  1. #1
    Registered User
    Join Date
    01-01-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    33

    Golf Group Tracking Bet Wins w/ Running totals by Golfer

    I manage a golf group of 35 people. We play 2 times a week and have several "Standard Bets" involved with each round we play.
    I have been manually recording the bets each round played and updating the winnings for each golfer individually by the particular bet they won that day.

    I am trying to create a workbook that has a "standard input work sheet" that would be used for each round (the bet category and amount of bet won) that I can print as a report that will also post the bet type and the amount won to the specific golfer that winning the bet that day.

    That part in pretty part is pretty straight forward -where I'm lost is how to have that information post to the particular golfer and maintains a running total for the season.

    In my mind I see this like a weekly sales report showing who sold what that week and then having that information post to the specific salesperson with running totals by product and dollars sold that could be used as an annual report.

    I have a basic level of Excel experience and have looked at different ways to accomplish but linking the information to a specific golfer and keeping a running total by golfer far exceeds my knowledge level.

    I have attached the foundation workbook to provide a better understanding of what I'm trying to accomplish.

    Any direction would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-09-2021, 05:24 PM
  2. Stats (points) tracking for a disc golf league
    By sennsm in forum Excel General
    Replies: 30
    Last Post: 05-08-2020, 11:10 AM
  3. [SOLVED] Golf Tracking Help!
    By Dswags115 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2017, 09:17 PM
  4. Replies: 5
    Last Post: 03-11-2015, 03:01 PM
  5. I need help formulating running totals in a time tracking sheet
    By MetroBOS in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-27-2014, 01:34 PM
  6. Avid Golfer looking for random golf foursome pairings generator.
    By Harvey Swartz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-04-2012, 11:47 AM
  7. [SOLVED] excel for tracking golf scores or handicap
    By RJ in forum Excel General
    Replies: 0
    Last Post: 01-17-2006, 12:45 AM

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