Pulling data from web into excel from hyperlink in cell

[shinzon2006]

Hello,

I have a complex issue here. Basically i work for company "X" and i need to take a URL say in cell A1 and return a specific part of the page in the cell. But there are 30,000 different URLs. The information on the page is always in the same spot. No idea how to start to do this. As an example lets say i have the website "https://www.google.com/#q=toys&safe=off&tbm=shop" (random website i just pulled) and the spot "Your location" is always the data i need it to pull. So Basically i need it to Read A1, connect to the web, grab the 1 word data and return it to A2, then repeat 30,000 times. (Yes i know this will take awhile to run, but it beats the alt of going to each link and copy paste.) Can anyone help?

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[shinzon2006]

I have changed the title as requested. Sorry about that, i am new here. I hope the new title is satisfactory.