Get data from multiple hyperlinks - TechRepublic
Question
August 20, 2014 at 06:24 PM
slnapier3

Get data from multiple hyperlinks

by slnapier3 . Updated 11 years, 9 months ago

I have a list of over 200 web hyperlinks in an excel spreadsheet (2010). Is there a way to have Excel open each link, get the information & import it back into the same spreadsheet?
For example, each hyperlink is for a different assignment. I need it to pull the type, requirements, duration & compensation. so the spreadsheet looks something like this:

Assignment 1 – Type – Duration – Requirements – Pays
Assignment 2 – Type – Duration – Requirements – Pays

Is there a to do it?

This discussion is locked

All Comments