Store previous cell value

Hi,

I have spreadsheet that is used to record informaton that my team inputs about the work they complete.

In specific, I am trying to track slippage in "Date due" dates of individual pieces of work i.e. currently I have 5 columns on a worksheet (column W:AA) side-by-side that are called "Date Due"/"Date Due (2)" etc.

This adds to the length of the spreadsheet, which puts people off filling it in.

I want to be able to have just one column called "Due Date" that people will enter the continually changing date in but will record these mulitple changes in date and store these dates in hidden columns beside this "Due Date" column.

So far I have found this code that prints the value of the change in A1 and stores it in the rows below, but I need columns and for it to work on each line down to row 2500 (as I am tracking individual pieces of work).

Please Login or Register  to view this content.

Any help with this would be much appreciated!