You will need to (use a macro) move to another sheet.

--
Don Guillett
SalesAid Software

"ChrisT" wrote in message
...
Web query is easy to schedule 5 minute refresh, however I want to retain
this
5minute data to create a database continuing throughout the trading day to
generate 5 minute intraday price/volume data, my question is how can I
move
the data up or down so as not to remove the previous 5minutes data as the
new
data is generated. Any suggestions appreciated. thx