Importing data to excel using a dynamic URL that uses the input of cell a1

Question

Hello,

I am starting on excel and I have a ambitious (for me me that don´t now much about excel) request,

I want to import certain information to fill a form on excel using a URL.

This URL needs to add a client number at the end to access the needed information.

I would like to use the Data From web method that is simpler for me, (but I am willing to learn more difficult ways if explained to me).

I am using the advanced mode of data from web and on the first part I insert

http://Abc.com/Pages/aspVIC021.aspx?ZCLIENTE=

And on the second part I use A1

What I pretend to achieve is that the first part copies the number from cell A1 to complete the URL

for instance if the value on cell A1 is 12345679, the URL would be http://Abc.com/Pages/aspVIC021.aspx?ZCLIENTE=123456789

Thank you very much in advance for any help that can be provided.

Answer 1

Hi @Emanuel Correia

You may use Power Query.

The reference:

Changing a URL in a Web Data Query based on a cell

Change URL with dynamic values based on values in a table

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---