+ Reply to Thread
Results 1 to 7 of 7

Monthly golf tracker: Merge multiple worksheets to summay sheet

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Augusta,GA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Monthly golf tracker: Merge multiple worksheets to summay sheet

    I am not sure if this problem can be solved with formulas & functions or if I need to post this problem in VBA.

    This started out as a simple spreadsheet, but now my friend wants to be be able to graph stats using cumulative data. This workbook started out as a monthly golf tracker, but now I am trying to create a summary worksheet. I created worksheet "graph data" and I want to populate the respective columns with data from the monthly worksheets. The rounds played each month may be different, but it will be no more than 15. Score = v4:418, eagle = y4:y18, birdies= z4:z18 from the montly spreadsheats. I have not created all 12 months yet but I will add them as I build this spreadsheet. Is there a method to merge this data, or would I be better off starting over with a master sheet for data entry and pulling data from the master to each month.

    Thanks for any advice or assistance.

    Adam
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    Hi

    Not sure if this what you want?
    =SUM('March2013:July2013 '!V4:V18)
    If so, then you can use the same principle for the other calcs?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,246

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    Hi adam,

    I collect golf scores also. I'd suggest you keep all the scores in a single table and do a Pivot Table or AutoFilter to show a single players scores.

    Find attached what we have been doing to see if it helps you develop your system.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    09-05-2012
    Location
    Augusta,GA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    Thanks for the quick answers but they are not exactly what I was looking for. =Sum will not work because I want the "graph" worksheet to copy all the individual rounds from each month, and the respective stats for that round. I should end up copying 8-10 rows from each each monthly worksheet. I will use the "graph" data to generate a line graph showing score, eagles, birdies, pars, bogeys, double, for each round. This way he can see the trends over time.

    The other spreadsheet may work for another anohter project I have for our golf trips.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    could you show some sample answers in your table please (enter manualy if necessary)

  6. #6
    Registered User
    Join Date
    09-05-2012
    Location
    Augusta,GA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    I copied the data from March2013 and April2013 to Graph Data as I would like it to appear. The Graph Data should get longer as more rounds are inputed each month.
    Attached Files Attached Files

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Monthly golf tracker: Merge multiple worksheets to summay sheet

    OK that makes it clearer, thanks

    Maybe some-one will offer a better solution, but until then, give this a shot.

    A4 =March2013!V4 copied across and down 15 rows
    A19 =April2013!V4 copied across and down 15 rows
    repeat for all months

    Then apply filters, and filter out all blanks in column A. Hidden (and filtered) rows will not show on a chart

    (messy, I know)

+ 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