Hi all
Firstly, thanks for this forum, have found so many useful tips over the years on the website & forum for Excel things - this place is a godsend!
Had a (possibly) complex question regarding a project I am doing.
I am working on building a database of all players for a football game that I play (Pro Evolution Soccer)
Screenshot - http://i.imgur.com/3w1IDHm.png
I have all the data extracted from the database of players that I have, and have put a URL for every player to their profile page on a football database website called Transfermarkt.
What I needed to do is for a script to be put together to automatically go to the URL in column B, and extract the teamname the player is currently at, and for that data to be pasted in to Column D (2014 Team). Otherwise, I am going to have to click on all 10,000+ links individually and copy & paste the team name manually.
Is there a way I can do this automatically? would save me a LOT of time to do it.
So for example:-
in row 631, there is the player Giannis Zaradoukas.
His player profile page on Transfermarkt is:-
if I go to that URL it shows that his team is now Platanias Chania for 2014, whereas he was at Aris Thessaloniki in 2013. I just need to get the latest data for the team extracted for every player.
I am using Excel 2010, and I have to be honest, I only know basic Excel stuff with small amount of formula knowledge.
Would be great if someone could assist with how to go about doing this procedure automatically via VBA, it would save me 50+ hours of work (at an estimate)
If you require a copy of the excel file in order to do it for me rather than pasting the code in the thread please just ask and I'll upload the sheet.
Thanks in advance!
Regards
Firstly, thanks for this forum, have found so many useful tips over the years on the website & forum for Excel things - this place is a godsend!
Had a (possibly) complex question regarding a project I am doing.
I am working on building a database of all players for a football game that I play (Pro Evolution Soccer)
Screenshot - http://i.imgur.com/3w1IDHm.png
I have all the data extracted from the database of players that I have, and have put a URL for every player to their profile page on a football database website called Transfermarkt.
What I needed to do is for a script to be put together to automatically go to the URL in column B, and extract the teamname the player is currently at, and for that data to be pasted in to Column D (2014 Team). Otherwise, I am going to have to click on all 10,000+ links individually and copy & paste the team name manually.
Is there a way I can do this automatically? would save me a LOT of time to do it.
So for example:-
in row 631, there is the player Giannis Zaradoukas.
His player profile page on Transfermarkt is:-
if I go to that URL it shows that his team is now Platanias Chania for 2014, whereas he was at Aris Thessaloniki in 2013. I just need to get the latest data for the team extracted for every player.
I am using Excel 2010, and I have to be honest, I only know basic Excel stuff with small amount of formula knowledge.
Would be great if someone could assist with how to go about doing this procedure automatically via VBA, it would save me 50+ hours of work (at an estimate)
If you require a copy of the excel file in order to do it for me rather than pasting the code in the thread please just ask and I'll upload the sheet.
Thanks in advance!
Regards
Last edited: