Extract data from different webpages
 

Hi,

I need to macro that can extract data from various webpages.
Basically, each employee have 1 webpage with the following data:-
a) Employee ID
b) Last Name
c) First Name
d) Dept1
e) Dept2
f) Email Address

The Excel worksheet will have the Employee ID in column A (say
A1:A100).

The macro will take the Employee ID in column A and the extract the
data for Last Name (col B), First Name (col C) and so on till Email
Address (col f).

Did a search on this forum, and was not able to find a close
match/similar question. Appreciate your help.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Extract data from different webpages
 

Hi,

Anyone have any good idea on how to do this macro?:confused

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com