Jonathan has attended:
Excel VBA Intro Intermediate course
Extracting data from a website
Hi. I have a list of names in Excel.
1.John
2.Jane
3.Jenny
4.Jacob
....
....
50.James
On a website there is a spreadsheet with various bits information about these people (age, income, sex, children..). The names on the website are not in the same order as in the Excel spreadsheet. Is it possible to write a macro to extract a specific part of the website spreadsheet (eg. only the income column relating to the various people) into the excel spreadsheet?
Thank you in advance!
RE: 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