Macro for multy links from the Web

Hi!
First sory for my bad english.

I need help for, how to automate with macro import data from web.

I have link(s) that i manualy paste in data from web but i wonna automate this with macro.

example of what i need;
In cell A1 is link that i need pull/import all page in A2 and link from B1 to B2 and in that direction further....

1.JPG

Please if aneyone know macro code for this query or something similar that will help me not to do that manualy!
Tnx

What kind of data are you scrapping? Is a single data or a table? If it is a table, you can use excel's built-in function as you highlighted on the picture. All you need to add is a loop where the code goes to each cell in a loop and fetch the URL. It is easier to help you if you could attach an excel sample, not a picture. On the sample book, you could include list of URLs and your desired result, that is, what you want to get from the URL.

Hi Dario,
The site is in your local language. When I try to translate it using Chrome, the site requires some searching. These 2 values in A1 and A are inputs. What do you want to get from the site? This does not look like you are trying to get a table.

Okay, it easy to adjust the code. All you need to is record the macro when you do it manually. I will then adjust the code.
just record the macro and post it here.

Ok, i make for first two links macro. What i need is now if i change links that macro automaticly copy data for them.

https://www.dropbox.com/s/5j767yugr7...inks1.xls?dl=0

Try the attached. The links are in A3,B3,C3 and so on.

Tnx alot for your time. I will try it and let u know how it is.

I tested and it works better that i wonna
Thank you so mutch once more!

You are welcome!