Excel spread sheet problem

[LoggerHead]

I have excel getting data from my wonderware program. Every time my data changes in wonderware it is updated in excel. My problem is that I have a formula in one cell to gather this data. Each time the value changes in my wonderware program it changes the value in that cell. What I am trying to accomplish is to create a data base that samples that data at a regular interval and stores it in a vertical list in my spread sheet. In other words every five minutes I would like to write the new data in a cell directly below the previous cell without losing or changing the data in the cell above it. I'm not sure if this is the proper forum for this question but after looking at some of the topics it seems to be a good place to start. Any help or direction would be very helpful.
Thanks in advance,
Daymond

 

[IRstuff]

As general rule, the Engineering Spreadsheets forum: forum770, is the place to post this type of question.

Suggest that you red-flag and ask site administration to move it to the spreadsheet forum.

What is putting the data into your spreadsheet? Can you not get it to insert a line after copying the data?

Otherwise, you'll need to write a macro to insert a line above the cell in question after detecting a change.

TTFN

 

[LoggerHead]

Thanks for directing me to the proper forum. I will try inserting a new line above that one and recording a macro to do this every time.

Daymond