Hi there,
This is going to be very difficult to explain in words alone but I will try.
I have a live scores feed into excel. It gives me Sets, Games, Points and the current server at that moment in time. I want to record the point by point history as the match plays out.
Below is the live score feed;
<tbody>
</tbody>
And below is how I'd like to record the above data as it changes.
<tbody>
</tbody>
It feels like this is possible with VBA but I'm new to it and have only ever made a few adjustments to existing code.
Any help is greatly appreciated and if you happen to live in Sydney I'll treat you to a Schnitzel and Beer!
Thanks
This is going to be very difficult to explain in words alone but I will try.
I have a live scores feed into excel. It gives me Sets, Games, Points and the current server at that moment in time. I want to record the point by point history as the match plays out.
Below is the live score feed;
Player | Set | Games | Points | Server |
Yafan Wang | 0 | 4 | 30 | FALSE |
Junri Namigata | 0 | 2 | 40 | FALSE |
<tbody>
</tbody>
And below is how I'd like to record the above data as it changes.
Set | Games | Server | Point By Point | ||||||||
Yafan Wang | Junri Namigata | Yafan Wang | Junri Namigata | ||||||||
0 | 0 | 1 | 0 | Yafan Wang | 15-0 | 30-0 | 30-15 | 40-15 | |||
0 | 0 | 1 | 1 | Junri Namigata | 15-0 | 15-15 | 15-30 | 30-30 | 40-30 | ||
0 | 0 | 2 | 1 | Yafan Wang | 0-15 | 15-15 | 30-15 | 40-15 | 40-30 | ||
0 | 0 | 3 | 1 | Junri Namigata | 0-15 | 0-30 | 15-30 | 15-40 | |||
0 | 0 | 4 | 1 | Yafan Wang | 15-0 | 30-0 | 40-0 | ||||
0 | 0 | 4 | 2 | Junri Namigata | 0-15 | 15-15 | 30-15 | 30-30 | 40-30 | 40-40 | Ad-40 |
<tbody>
</tbody>
It feels like this is possible with VBA but I'm new to it and have only ever made a few adjustments to existing code.
Any help is greatly appreciated and if you happen to live in Sydney I'll treat you to a Schnitzel and Beer!
Thanks