Record cell change and date

[kayakginge]

Hi All,

I have had a read through other posts can cant find exactly what i am after, i can find script for each individual part but when i try and put them together i can can only get one half to work.

I would like to monitor target cells in another sheet and record the value that was in the target cell and record it in another sheet in column B and the date the change was made in column A.

So it would look something like this.

Sheet 1

Cell B19 is changed from 12 to 13 on the 20/11/18

sheet 2

A1 would now read 20/11/18
B1 would now read 12

Next time sheet 1 B19 is changed from 13 to 14

sheet 2

A2 would read date changed
B2 would read 13

i would like to do this for a number of target cells and record them in different columns, i assume this will just be a matter of copy and pasting the code.

Ie also record changes in sheet 1 B20 and first previous value would be stored in sheet 2 C1 and date in D1 etc

Any help on this would be greatly appreciated and i thank you in advance. If this is not clear enough please let me know.

Many thanks

 

[Kamolga]

You are welcome, thank you for the feedback.