Progresive cell

[Derek Jeanes]

Help - I am really struggling with this problem and would appreciate any help. I want to be able to input data (a date) into a cell and then have that data automatically update a table. When I change the data is in the input field, I want the new data to update the same table but in a different cell and still retain the data in the other cell. IE. If I input a date into E7 I want that date to automatically update G7 and then when I change the date in E7 I want to retain the date in G7 and update H7 with the new date and so on. This is to retain a record of dates certain work was done.
Thanks in advance.

 

[awoohaw]

I think this is best done with a user form/data entry form.
There is no VBA. It is standard excel functionality.