Hi There

I need to import data from a website into an spreadsheet, I open the web query and select the necessary table. On the date range properties I change the refresh to 1 minutes as the data refreshes every 45 second on the web.

The problem I am having is that when the data refreshes it overwrites all the old cells, is there a way to make the refresh move to the cells below the prior refresh therefore not overwriting?

If possible could someone please give me some advice on best option.

Thank you