On Value Change Copy Data To Another Sheet

Hi All,

New to this site and VB ability is only fair. I have a sheet in Excel (sheet 1)which reads in eleven values. If the data in the 11th value changes then I would like to copy the other 10 values to sheet 2 appending to previous values copied. Date and time on each copy would also be nice if possible.

The values in sheet 1 are being read in via an OPC server from a machine and only change at the and of a batch which could take a few hours.

We are trying to gather this information as a test just for stocking levels on a short term basis. We may look at a more sophisticated method after our trial period is completed.

Any help or pointers would be appreciated.

Best Regards

Roth