Wasn't this asked and answered already?
Create a macro to copy/paste the data to another sheet run the refresh.

--
Don Guillett
SalesAid Software

"SteveC" wrote in message
...
Hi,

Assuming I have a web query that returns a column of data, is there away
that every time I refresh the web query that it downloads refreshed data
into
the adjacent column automatically?