I'm pretty confused at the moment, so I'm not sure if I can explain my problem in a sensible fashion, but here goes.
I am working as a scout for my team at a robotics competition. I will have five fellow teammates, all with our computers, watching the matches and recording information so in the final rounds we can pick the best alliances. What I want is to have our computers synced(this has already been accomplished) and have two excel files that sync information from one another. One with a form which we fill out for each team in each match, the other a final sheet where everyone's information combines. The first form will contain information such as Match Number, Team Number(There's approx. 70), Match Score, Autonomous Score, Win or Lost, High Goal scores, Low goal scores, etc.
What I am aiming for is for each person to be looking at one team during the match and fill out the form accordingly, then have it sync to the final sheet. Do I have to make this form into a table and use a pivot table to synchronize them? Any help would be much appreciated! Thanks very much
I am working as a scout for my team at a robotics competition. I will have five fellow teammates, all with our computers, watching the matches and recording information so in the final rounds we can pick the best alliances. What I want is to have our computers synced(this has already been accomplished) and have two excel files that sync information from one another. One with a form which we fill out for each team in each match, the other a final sheet where everyone's information combines. The first form will contain information such as Match Number, Team Number(There's approx. 70), Match Score, Autonomous Score, Win or Lost, High Goal scores, Low goal scores, etc.
What I am aiming for is for each person to be looking at one team during the match and fill out the form accordingly, then have it sync to the final sheet. Do I have to make this form into a table and use a pivot table to synchronize them? Any help would be much appreciated! Thanks very much
