Extracting data from a website

Hi Jonathan, thanks for your query. This is possible, but will involve some coding. The following link runs you through a slightly different example of getting data from a website, but the basic principles of what you will have to do are the same.

http://www.mrexcel.com/tip072.shtml

My first stop however, would be to run a web query to the site to see if I could port the table of data directly into Excel. There's a good (2003 based) walkthrough here:

http://www.mrexcel.com/tip103.shtml

Look for Get External Data - From Web on the Data tab in Excel 2007. If you can get it into Excel that way the rest should be simple.

Hope this helps,

Anthony