Instead of an auto refresh in the query use an
ONTIME macro to copy the columns and then refresh the query.
look in vba help index for ONTIME

--
Don Guillett
SalesAid Software

"samprince" wrote
in message ...

Thanks for your advice.

How would I be able to incorporate a timed action into the macro or
have it copy the cells into the next available column when the cell
data is auto refreshed by the web query each 10 minutes?


--
samprince
------------------------------------------------------------------------
samprince's Profile:
http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=539307