Hi

I have little knowledge of vba and I wonder if someone could help me with my problem please.

I need to take a record of an ever changing cells value in Sheet 1 every 30 seconds and place it in cell A1 of Sheet 2. Then 30 seconds later record that cells value from Sheet 1 again and this time place it in cell A2 of Sheet 2. Then cell A3 and so on, continuously into a separate cell each time in column A.

Or another option would be to record the information into cell A1 every time and then push the cells down so that the new record always goes into A1, but this seems harder I think.

I hope you can understand what I mean and many thanks to anyone who can help.