Extracting data from a website

Resolved · Urgent Priority · Version 2007

Tue 9 Aug 2011, 15:44 Delegate Jonathan said...

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!

Thu 11 Aug 2011, 15:23 Trainer Anthony said...

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

Thu 18 Aug 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips