I am working on creating a live Excel Dashboard to monitor some machines. I have a program pulling information from a PLC and displaying it in Excel in real time, values change every second. I need a way to copy the values that are displayed to a row underneath and then insert a new row to copy values again. Essentially creating a FIFO cascade with the information that is displayed on the first row. I need to do this every couple of seconds. I want to then use that information to create a running chart or graph displaying the last 30 minutes of information in an easy to view format. Is this even possible with Excel and VBA?
Thanks
Bookmarks