Hey All,

I'm wondering if it is possible to extract just particular pieces of data from a list of URLs in Excel 2010. Let me explain what I mean. So, I have a list of ~700 organizations and I have their URLs on the adjacent column:

Capture.jpg

Now what I want to do is get only the organization presidents' names and email addresses on the columns adjacent to the URLs on the same sheet automatically. For example:

Capture2.jpg

I wish to automate this process because 700 organizations is a lot to go through. Until now, I still haven't figured out a macro/VBA to solve this problem. Is it even possible to just get the presidents' names and email addresses next to the URLs automatically? If not, is it possible to automatically get the text content of the URLs. That'll be good enough since I can split the data after getting the text content of the ~700 pages. Think I'll paste the link of the document URL here for you as well in case you want to test your formula/VBA/etc.:

https://www.dropbox.com/s/nmbrlmil5c...anizations.xlt

Thanks for taking the time to read this thread and help out.