Hi,
I am looking to pull information from certain websites and put them in excel. I'm not quite sure where to start. I have tried the search option but it is not returning anything.
Any help? or where I can start?
Thanks!
Hi,
I am looking to pull information from certain websites and put them in excel. I'm not quite sure where to start. I have tried the search option but it is not returning anything.
Any help? or where I can start?
Thanks!
Last edited by JRLats; 12-19-2009 at 02:11 AM.
Good morning JRLats
...and welcome to the forum!!
Bit difficult tp say without knowing exactly you want to extract, or from where, but in general ...
To import data from a web page to Excel go to Date > Import External Data > New Web Query.
Put the http address in the box at the top and click "Go". Follow the prompts from there.
Just be aware that the data might not come across exactly as you need it and just be prepared to do some alterations with your formatting.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thanks for the welcome!
And thank you for the tip!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks