PDA

View Full Version : Extract data from website in an Excel Spreadsheet



sh_obaid
12-17-2011, 08:16 PM
My Excel Spreadsheet has columns named "Hospital Name | Overview | Address | Phone | Fax | Contact Person 1 | Contact Person 1 Title | Contact Person 2 | Contact Person 2 Title | Contact Person 3 | Contact Person 3 Title"

I have a website i.e.
http : // biz. yahoo. com / ic / 524_cl_all .html (Remove spaces)

Whenever I click on any hospital name, it gives me my required information and I would like to extract so that it adds each record after record in the following manner:

This text should go in column named "Overview": Abbott Northwestern Hospital helps bring twins into the Twin Cities -- along with triplets, quadruplets............

This text should go in column named "Address": 800 E. 28th St.Minneapolis, MN 55407

This text should go in column named "Phone": 612-863-4000

This text should go in column named "Fax": 612-863-5667

This text should go in column named "Contact Person 1": Jeffrey D. (Jeff) Peterson

This text should go in column named "Contact Person 1 Title": President

This text should go in column named "Contact Person 2": Daryl Schroeder

This text should go in column named "Contact Person 2 Title": VP Operations

This text should go in column named "Contact Person 3": Sandy Schmitt

This text should go in column named "Contact Person 3 Title": VP Strategic Development, Allina Hospitals and Clinics


Please help!!!

shrivallabha
12-17-2011, 09:54 PM
Read this advice on Ken Puls' website on cross-posting:
http://www.excelguru.ca/content.php?184

You have cross posted this on MrExcel. Here no one has replied it but on MrExcel you are getting leads to get your goal.
http://www.mrexcel.com/forum/showthread.php?t=599734

I think, you did it unintentionally. Take care in future posts.