On Sheet 1, I have a list of teams in D3 through D37
In B3 through B37 I have a list of team members
Teams can have anywhere from 1 to 10 members
There can be between 1 and 12 teams
In E3 through W37 I have points accumulated by that team member
On Sheet 2, I need the following:
Team names automatically listed in column A by pulling the data from Sheet 1
Corresponding driver names listed in column B
Points from Sheet 1 E3:W37 listed in column C through U for the corresponding driver
Total points for each team listed in column V
Sorted by column V descending
Update upon sheet activation
However, I only want the team name listed once on Sheet 2 column A, and I only want the total points listed once in column V, both in merged cells. For instance, if there were 6 teams, I would want 6 rows in column A merged with the team named displayed within, and similarly, in column V, I would want 6 rows merged with the total points listed within, yet I would want team members and points listed on individual rows.
So in short, this has to account for a lot of dynamic data (teams, number of teams, team members, number of members, points) and automatically update upon sheet activation.
Thanks
In B3 through B37 I have a list of team members
Teams can have anywhere from 1 to 10 members
There can be between 1 and 12 teams
In E3 through W37 I have points accumulated by that team member
On Sheet 2, I need the following:
Team names automatically listed in column A by pulling the data from Sheet 1
Corresponding driver names listed in column B
Points from Sheet 1 E3:W37 listed in column C through U for the corresponding driver
Total points for each team listed in column V
Sorted by column V descending
Update upon sheet activation
However, I only want the team name listed once on Sheet 2 column A, and I only want the total points listed once in column V, both in merged cells. For instance, if there were 6 teams, I would want 6 rows in column A merged with the team named displayed within, and similarly, in column V, I would want 6 rows merged with the total points listed within, yet I would want team members and points listed on individual rows.
So in short, this has to account for a lot of dynamic data (teams, number of teams, team members, number of members, points) and automatically update upon sheet activation.
Thanks
