I've got an excel file with entries of player names and their Transfermarket.uk links to their profiles.
Entry number is about 1600,1700,and constantly growing,so i want to make it automated.

My excel needs to 'click' each link that is in it,read out the player's status on the link,then write it into adequate cell in excel.


I already have a working code,thing is,it sometimes reads the wrong data if player's status is different.
I don't know how to point the code to specific data on these pages.

These are possible statuses of a players:
http://www.transfermarkt.co.uk/en/li...ler_28003.html
http://www.transfermarkt.co.uk/en/di...eler_8024.html
http://www.transfermarkt.co.uk/en/ma...er_250970.html

Here,i'll attach the file in question,so it's more clear to you guys what i did and what could be wrong there(i guess its the fact that i'm not pointing out to some specific web element on page,but rather to a cell on a sheet that contains a 'scrape' of that page)

Rows 93,94 for example contain the 'wrong' values
transfermarket SVIH igraca testiranje.xlsm

Formula: copy to clipboard 
Please Login or Register  to view this content.