Record date cell data is changed - not VBA

[chally3]

Good Morning all and a Happy New Year,

Can anyone help please, if this is possible without using VBA (due to security restrictions).
We have a spreadsheet template that I wish to record the date a cell change was made, is this possible without VBA?


IE as a default all cells in column H are a default blank - but the first part of our process is to check every row and add a N (this is a record of request for quotations being sent), but I would like to record the date they are changed to a "Y" from "N" (in any column is fine to show that date, but will say "M" ) Column "H" will always be populated with a N or Y for every row with data in)


Hope this helps, Thank you

Kind Regards
Mark

 

[Joe4]

Have a look here for a method that does not use VBA: Excel - update a cell value when another cell changes without VBA

 

[chally3]

Have a look here for a method that does not use VBA: Excel - update a cell value when another cell changes without VBA

Thank you

 

[Joe4]

You are welcome.

 

[chally3]

You are welcome.

Works perfect and has saved a major headache, thank you and a Happy New year to you