Hard to tell without a file to test but you can have each webfetch
goto the next column or do your fetch in one sheet and have your macro
copy to the next available column in the other sheet. Send me a file
if desired.


On Feb 15, 1:46*pm, eran3185 wrote:
Hi
I want to use the web query
What's the problem?
The data are obtained in column A
I want to retrieve data every day & I want to creates a situation where
today's data override the immigrants of yesterday's data
Does anyone know how to create a situation where the data of today will
be on column A *, the data of tommorow will be on column B *etc.

--
eran3185