merging data from internet

[ylijohe]

how can I merge data to sheet3
from internet page
http://marketinfo.eqonline.fi/eq/index/stocklist.html?list=finland

that contains delayed stocklist?

Also converting to numbers and erasing hyperlinks from copied data would be convenient.

 

[Jim North]

...welcome to the board!!

I've not done much in this area, but if you search this board for "WEB QUERY" or ".IQY" (without the quotation marks) I think you will find what you are looking for.

 

[ylijohe]

Thank You!

I think I solved the problem (if it was a problem at all), here is my solution to import data from net.

As you can see, I had to open an extra sheet for temporary hold list because vlookup did not function right if I organized the imported list in alphabetical order. The vlookup started looking from altered places no matter what I did, but this temporary sheet solved this problem.

Here is my solution, click "import data from internet"....

http://www.geocities.com/ylijohe/excelsolutions.html