Hello, I am trying to create a macro which webscrapes a table (I am interested in the biggest table) from the website http://www.soccerstats.com/team.asp?...land&teamid=15

So far I can get the code to navigate the website to a specified team (see code below) but when I try and scrape the data it a)pulls everything from the page, not just the data I want and b) puts it all in one column

Does anyone have any experience webscraping? Thank you for your help.

VBA code:

Please Login or Register  to view this content.
edit: I tried to post the html code for each column but unfortunately the website wont accept the post if it has html code (redirects to "Access Denied - Sucuri Website Firewall")