So i'm using an external web query to receive data in realtime from a local ip host on my computer. So, I have a sheet of numbers in excel with a value column, which I need to log at a rate of 1hz.

So my question is...how can I refresh the data (I can do it manually by pushing the little button on the web data tool bar), so say cell A1 gets copied into a new spreasheet at a rate of 1hz, but instead of replacing itself, it moves to a new row.

I know a loop will be involved, so lets say while A1>0 then log the data to a new file at a rate of 1hz.

I found a timer function and can get my data worksheet to refresh at a rate of 1hz, but i don't know how to make a loop to take that data and place it in a new worksheet and move down a row each time.

Thanks a lot!