Shifting cells on a 1 second interval

[Hrsjolson]

Hi,
I am wondering if it's possible to have excel take a live value being read through RS Linx and place that value in a cell then shift all the cells down in that column once every second. Basically I am trying to store data that I can build trend files with. Also I would like to be able to start and stop this based on a different cell maybe being a 1 or 0. Also while its doing this write to another cell a 1 or a 0 so I can tell remotely if its recording or not.

Thanks for the help!