Thread: macro code for constant copy but variable paste cell

hi
im sorry if this has been answered before, i think it has but im having trouble explaining what im trying to do so searching for it online is really hard.

i have a xml feed which is updating a cell constantly, i would like to log that value in new cells over 8hrs.

so far my macro can copy the cell, paste the value into a new cell(lets say A2), then wait x seconds.

i can manually put in the next lot of code, which would be the same as the first but with the paste cell values changed, but i would like to repeat the code for a long time. ie i would like the copy cell(thats value is always changing) to stay on B1 but paste in a new cell every x seconds all the way down the column.

i am very new at this but i have found code to loop but i need to have the right code to loop.

any help would be appreciated, even if its the name of the process.

thanks