S
slc
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.
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.