Hi,

I have range in A1 : B10,
Col A - Names
Col B - production data

In a day ( 8 hour work), I need to update data on every 2 hour in a
seperate sheet.
suppose one user update some production data at 8 AM then it should
captured in sheet 2.
And again the same user updated production data at 10 am then it
should add with the previous data similarly for different times.

Any macro code will be helpful.

Thanks