All
I'm wondering if it is possible to copy the entire row from sheet 2 to sheet6 when the date changes on a Cell in column L.
File attached records actions/projects as described.
Sheet2=records actions/projects.
Sheet6=keep a copy of sheet1 every time a date changes on column L, on any row or multiple times on the same row.
For example:
Sheet2 shows on row 6 (task 1), a user has changed/amended 3 times the Deadline date (column L), and I would like to keep a copy of the entire row to record the data prior to be amended, as per example on sheet 6 (user changed date on 22, 23)- 22/04 was the original date for the action deadline.
Next row will be copied to the next free row available in this instance row8.
The aim is, record and monitor how many times a date is changed and or delays in a project.
Thanks in advance.
R
I'm wondering if it is possible to copy the entire row from sheet 2 to sheet6 when the date changes on a Cell in column L.
File attached records actions/projects as described.
Sheet2=records actions/projects.
Sheet6=keep a copy of sheet1 every time a date changes on column L, on any row or multiple times on the same row.
For example:
Sheet2 shows on row 6 (task 1), a user has changed/amended 3 times the Deadline date (column L), and I would like to keep a copy of the entire row to record the data prior to be amended, as per example on sheet 6 (user changed date on 22, 23)- 22/04 was the original date for the action deadline.
Next row will be copied to the next free row available in this instance row8.
The aim is, record and monitor how many times a date is changed and or delays in a project.
Thanks in advance.
R