Forum Discussion
Solved
Date/Time Stamp a Changed Excel Entry
I want to add a date/time stamp to each row when that row is updated. I know I could do this in a macro but the workbook might need to be used in mobile Excel Online and macros aren't supported ther...
RiverKing You'll need something as described in the attached link:
Thanks for the suggestion but this is something I've already tried. The problem with it is that changing column A in any row resets NOW() for all rows in which An<>Nn.
This is how it should be, because the Now function is a Volatile function. As time changes constantly, the Now function will also change constantly. Changes in any cell of the Tab (Worksheet) you are in will update the Now function. As far as I understand, you want the date of the change to remain constant. Right?