Hi I am new excel and still trying to establish which of the many funtions would be best for the following requirments.

I am looking for away to dynamically update a data range with a limit of 30 records.

e.g Cell A1 has a new value entered in to it every 1 second.

Lets say data range to be stored from C1 to C30.

Everytime the data is entered in A1 it adds the value to C1, with the value in C1 moving to C2, value in C2 moving to C3 etc up to C30.

After C30 the data is deleted hence - only the previous 30 secs of data is shown at one time.


Hope you can help!!!!