Hi there, I am unsure how to do this properly, but I've managed to figure out that a Macro is perhaps the best way to go.
I currently have a single sheet that I need to update one column based on a link that has been pre-generated.
Company First Name Last Name Position Salary Group Gender Course Completed Country Link Company 1 Bob Joe HR Manager 2 Male Excel 101 10% USA Link [email protected]
The link is already generated and when you click on it, goes to the relevant page.
However, this excel has in excess of 500 people in a list and it would be cumbersome for someone to click on each link, search out the % completion, then paste it into the appropriate column. I was wondering if a Macro could automatically do this as and when required.
The rest of the information is pulled from the local Active Directory using another Macro (works like a charm). Only the % complete isn't as that resource is from a website.
Any help would be very much appreciated.
I've tried to use the DATA>GET EXTERNAL DATA>IMPORT FROM WEB function, but to no avail since there are multiple occurrences on one page.
Bookmarks