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;
[TABLE="width: 435"]
<tbody>[TR]
[TD]Player[/TD]
[TD]Set[/TD]
[TD]Games[/TD]
[TD]Points[/TD]
[TD]Server[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Yafan Wang[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]30[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Junri Namigata[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
And below is how I'd like to record the above data as it changes.
[TABLE="width: 997"]
<tbody>[TR]
[TD]Set[/TD]
[TD][/TD]
[TD]Games[/TD]
[TD][/TD]
[TD]Server[/TD]
[TD="colspan: 2"]Point By Point[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Yafan Wang[/TD]
[TD]Junri Namigata[/TD]
[TD]Yafan Wang[/TD]
[TD]Junri Namigata[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]Yafan Wang[/TD]
[TD]15-0[/TD]
[TD]30-0[/TD]
[TD]30-15[/TD]
[TD]40-15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Junri Namigata[/TD]
[TD]15-0[/TD]
[TD]15-15[/TD]
[TD]15-30[/TD]
[TD]30-30[/TD]
[TD]40-30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Yafan Wang[/TD]
[TD]0-15[/TD]
[TD]15-15[/TD]
[TD]30-15[/TD]
[TD]40-15[/TD]
[TD]40-30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]Junri Namigata[/TD]
[TD]0-15[/TD]
[TD]0-30[/TD]
[TD]15-30[/TD]
[TD]15-40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]Yafan Wang[/TD]
[TD]15-0[/TD]
[TD]30-0[/TD]
[TD]40-0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]Junri Namigata[/TD]
[TD]0-15[/TD]
[TD]15-15[/TD]
[TD]30-15[/TD]
[TD]30-30[/TD]
[TD]40-30[/TD]
[TD]40-40[/TD]
[TD]Ad-40[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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;
[TABLE="width: 435"]
<tbody>[TR]
[TD]Player[/TD]
[TD]Set[/TD]
[TD]Games[/TD]
[TD]Points[/TD]
[TD]Server[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Yafan Wang[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]30[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Junri Namigata[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
And below is how I'd like to record the above data as it changes.
[TABLE="width: 997"]
<tbody>[TR]
[TD]Set[/TD]
[TD][/TD]
[TD]Games[/TD]
[TD][/TD]
[TD]Server[/TD]
[TD="colspan: 2"]Point By Point[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Yafan Wang[/TD]
[TD]Junri Namigata[/TD]
[TD]Yafan Wang[/TD]
[TD]Junri Namigata[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]Yafan Wang[/TD]
[TD]15-0[/TD]
[TD]30-0[/TD]
[TD]30-15[/TD]
[TD]40-15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Junri Namigata[/TD]
[TD]15-0[/TD]
[TD]15-15[/TD]
[TD]15-30[/TD]
[TD]30-30[/TD]
[TD]40-30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Yafan Wang[/TD]
[TD]0-15[/TD]
[TD]15-15[/TD]
[TD]30-15[/TD]
[TD]40-15[/TD]
[TD]40-30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]Junri Namigata[/TD]
[TD]0-15[/TD]
[TD]0-30[/TD]
[TD]15-30[/TD]
[TD]15-40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]Yafan Wang[/TD]
[TD]15-0[/TD]
[TD]30-0[/TD]
[TD]40-0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]Junri Namigata[/TD]
[TD]0-15[/TD]
[TD]15-15[/TD]
[TD]30-15[/TD]
[TD]30-30[/TD]
[TD]40-30[/TD]
[TD]40-40[/TD]
[TD]Ad-40[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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