Hello all,
I need help in copying cell values when a cell value changes. Background: I have developed a workbook that is linked to several different servers. Each sheet in the worbook is linked to a specific server. The servers are basically PLC's in a plant. I have running totals that are being monitored. Once the job is finished, the operator on the line presses a button and this captures a time stamp sent from the PLC. When this time (value) changes, I want to copy all of the data in a group of cells and paste them in cells below the "Running Totals". I want to do this 4 different times. In other words, I want to be able to capture the totals for the last 4 jobs that were run. I am somewhat familiar with VB so if there is a macro out there that will work, I should be able to modify it. I am using Excel 2010.
Thanks
Bookmarks