data capture

[gman26]

I would like to 'capture' the changing data in cell A1 and store it i
another worksheet or workbook. I have tried the IF statement, however
it does not work right. I am trying to store production data 3 times
day, 5 days a week, from one workbook to another.
Any help would be greatly appreciated

 

[Frank Kabel]

Hi
do you want to store each change of cell A1? some kind of logging?
If yes:
- how is cell A1 changed (manually)?

 

[gman26]

The data in the cell is constantly incrementing. It is automatically
updated by a program called RSLinx, the PC is communicating with a PLC
on the factory floor. At the end of the shift an operator resets the
counter (value in the cell the I want to store) just prior to the value
resetting to zero I want to store that value in another cell or
workbook.

 

[Frank Kabel]

Hi
how does the operator reset this value? manually or with a macro. If he
does this trhough a macro simply copy the value within this macro to a
separate sheet

 

[gman26]

The operator resets this value at the machine on the factory floor. H
has no intervention with Excel. When the RESET pushbutton is pushed,
will use another cell value to trigger the 'capture' of this dat
before it is reset to zero