I am trying to find a way of automatically inserting a date when a second cell has been altered. For example A1 = blank, if I then put any entry in A2, I want to show the date in A1 that A2 was altered.
I have already used the IF function using the NOW() function as an argument - but of course the date always changes thereafter whenever the workbook is opened or recalculated, as the cell is constantly reflecting (correctly) the NOW() function.
I just want to know when a cell was changed - sounds too simple to be difficult but I can't find a way of doing it. Can anyone help me with this?
I have already used the IF function using the NOW() function as an argument - but of course the date always changes thereafter whenever the workbook is opened or recalculated, as the cell is constantly reflecting (correctly) the NOW() function.
I just want to know when a cell was changed - sounds too simple to be difficult but I can't find a way of doing it. Can anyone help me with this?