Thanks a lot Narayan.. That worked perfectly...
One More question...
I want change in K3 to enter the date into L3
and change in K4 to enter the date into L4
and change in K5 to enter the date into L5
and so on....
Thanks for your help
This is the first time I am trying to use Excel triggers and have no clue hoe to so please spoon feed.
I have a cell with 5 possible values.
What I want to do is record the date when this cell was changed. depending on the selected value the date is recorded in a certain different cell...