Hi Yannick

In the module where the Web Query code is have a look for something like this
If it's the same, change it to False. When set to False, the code waits for the data to be imported before it proceeds, you can then add some code after the refresh code to copy the imported data line to another worksheet