Hi all,
Sorry complete newbie here with any kind of advanced programming, so please be kind
The problem I have is that I would like to automate (by way of macro or somesuch) the combination of two separate medal tables into one combined medal table.
If you look here
http://www.eastswimming.org/swimresults/2017/LC Champs Weekend Two/index2.htm
On the right hand side, under services, is a sub menu for "Medal Tables".
Click into that and we have the Norwich table and the Luton Table Carried over.
Underneath which is a combined medal table which I had to manually create by adding together the medals the clubs had gained at each meet, and then create a table and fill out the table manually with the combined scores.
as you can imagine it took a while.
I would love to be able to automate that process by use of a macro maybe (if that is possible) where I can import the two original tables into word or excel possibly, and it would then combine the two and produce one final table.
But I do not know even where to start, hence coming here to see if anyone with far more skill and knowledge than me could help some please.
If you could point me in the right direction any help would be much appreciated.
Thank you in advance.
Sorry complete newbie here with any kind of advanced programming, so please be kind
The problem I have is that I would like to automate (by way of macro or somesuch) the combination of two separate medal tables into one combined medal table.
If you look here
http://www.eastswimming.org/swimresults/2017/LC Champs Weekend Two/index2.htm
On the right hand side, under services, is a sub menu for "Medal Tables".
Click into that and we have the Norwich table and the Luton Table Carried over.
Underneath which is a combined medal table which I had to manually create by adding together the medals the clubs had gained at each meet, and then create a table and fill out the table manually with the combined scores.
as you can imagine it took a while.
I would love to be able to automate that process by use of a macro maybe (if that is possible) where I can import the two original tables into word or excel possibly, and it would then combine the two and produce one final table.
But I do not know even where to start, hence coming here to see if anyone with far more skill and knowledge than me could help some please.
If you could point me in the right direction any help would be much appreciated.
Thank you in advance.