LoggerHead
Industrial
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
Thanks in advance,
Daymond