For context, I am using a calc spreadsheet to read data from a programmable logic controller via DDE. That I already have figured out. What I cannot seem to find anywhere is the means to take that data and allow it to change cells downward each time a certain trigger value changes. Ideally this would allow me to make a set of numbers running over a period of time for records. Any helpful ideas with formatting or coding I’ll take, I’ve picked up this for this purpose alone so far, so I am painfully new to it and coding in general.
It took me a bit figuring out how to get it to work but once I figured out the naming and arrays it fit together, thanks for the help.