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
Bookmarks