Good day!

I've been trying to help solve my husband's problem but to no avail. Pls help us.

His problem is about saving data of a cell that he must update every hour to several cells of another sheet. He must save each changes to individual cell automatically.

Ex.

All update is done on sheet1 and the result is on sheet1 B2.

The result of the 1st update on sheet1 cell B2 is 12:30.
12:30 must appear on sheet2 C2.
2nd update on sheet1 B2 is 1:15 so 1:15 must appear on sheet2 C3.
3rd update must be on sheet2 C4 then 4th on sheet2 C5 and so on.

Please help. I am new with excel.

Thank you very much!