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

check out sumif and sumproduct functions in Help.
best wishes
Sreedhar

"muddan madhu" wrote:

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