Web Query

[mordernduke]

Hi,

Is it possible to Save old data when web query refreshes.

Mainly, I am extracting data from the net into the excel, and I want to refresh it every 5 mins.

The problem is, the data keeps refreshing on the existing data. I need to save the old data, and keep on getting new data on different cells.

Please help.

Thanks in advance.

[Cheeky Charlie]

Yeah, you'd need to use a macro to move the old data and refresh the query pseudo-manually (i.e. the automatic macro would effect a 'manual' refresh).

To do this we'd need an example workbook explaing your query and where the data would need to go.

[mordernduke]

Hi,

Thanks a lot for your help, even though I could not understand quite a lot.

The case for what I am looking for - I need data from a stocks site, considering a few stocks and there values.
Now, I want to refresh data every 5 mins, with the old data being where it was, and the new data should come automatically, below the old data (Leaving probably a line or 2).

Can you please help me out, as I have been pondering over this since over a week now.

Thanks a lot.

[Cheeky Charlie]

to do this we'd need an example workbook explaing your query and where the data would need to go.

1234567890

[mordernduke]

Yes, Very cheeky charlie. Very helpful.