I am a volunteer youth bowling coach and I run a youth scholarship tournament (TVMT) that runs from October to May each year. There are 2 days, Saturday is a scratch tournament and Sunday is a handicap tournament. Each participant earns points for each tournament they bowl, with the top 10 earning more points based on final placement for each division (70, 65, 60, 55, etc. down to 20 points then all remaining bowlers receive a minimum of 20 points). Scholarships are paid at the end of the season based on the points accumulated for the season, per division, both scratch and handicap.

I use tournamentbowl.com to run the tournament (scores, standings, etc). Each bowler signs up using their USBC# (unique identifier), but they can be in either or both scratch and handicap. The scratch tournament has 2 divisions based on average (up to 159, and 160+) and the Handicap tournament has 3 Divisions (under 115, 115-159, 160+). Each division has 3 sections to the tournament, 4 game qualifier (ie: SCD1, SCD2, HCD1, HCD2, HCD3), 1 Head to head for the top 8 bowlers (ie: SCD1-SEMI, etc), and then a stepladder of 3 games for the winners of the head to head (ie: SCD1-FINAL).  After the tournament, I can download a spreadsheet that contains all of the data that I need, but not in a direct usable format since it lists each section of the tournament separatly by short name (ie: SCD1, SCD1-Semi, SCD1-Final).

I have created a spreadsheet that takes the information from the downloaded .xls file and compiles it so I have a separate tab for each division with each bowlers games for ALL games bowled each day. It then assigns the points for each month per division, and creates a master list of AllBowlers. I have done this through macros and vba (which I am trying to learn as I go).

I also have a second spreadsheet that I use to track each bowlers average. In this sheet I duplicate my efforts by copying each bowlers games for each month by tournament (SC & HC) and by division, because if their average increases they go up to the next division. Once they are in that division, they can not move back down if their average drops. I have been doing this manually, up until now, but have been trying to use XLOOKUP to automate the process.

SO, HERE IS MY QUESTION, am I on the right track with using lots of macros, lots of xlookup and some vba or is there an easier way? I use Office 365.