You gotta be good to solve this one.
I have an excel spreadsheet that uses DDE. In a two cells, it grabs two current numbers from a datataker (real-time peice of monitoring hardware). This updates everytime new data is available.
Thing is, I want to keep the old data in two columns. All of this will get displayed in realtime on charts. I believe I need some VBA scripting to achieve this. It probably has to poll intermittently (in the background) to see if the values have changed, then append them to the columns.
Any VBA guru's out there like to waste some time helping me out with this one?