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
Bookmarks