Web query to save data and add to old data when updated

[batjl9]

Hi all

I was wondering if it were possible to save data from a web query and when the web query updates the newest data on the query is transferred over to the old data saved. In the past I have managed with the help of this website to save data from web queries, but this one would require all the data to be in one list and the lis would need to be updated only with the newest data on the query, so not sure if it is entirely possible without having to carry tasks out manually.

I have attached an excel sheet with a bit more info on.

Thanks
Gemma

[batjl9]

I managed to get it working using information from this thread.

http://www.excelforum.com/excel-prog...refreshes.html