Forum Discussion
Date of Last Modified for a Cell
Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd lik...
Thanks!
You got the formula the wrong way round, assuming that you want a timestamp in column D when the user enters a value in column D.
It will only work if column D is still empty when you create the formulas in column J. The formula in J5 should be
=IF(D5<>"",IF(J5<>"",J5,NOW()),"")
And remember that you have to enable iterative calculation in File > Options > Formulas.
If you want column J to be updated each time you edit column D, you need VBA code, not a formula.
ok, got it. I do want column J to be updated every time I update Column A. I tried to do a VBA code but it didn't work. I have no previous experience in VBA.
Thanks so much for your assistance!
Thanks so much for your assistance!
Make the folder containing the workbook a Trusted Location for Excel.
File > Options > Trust Center > Trust Center Settings... > Trusted Locations.
- Hans, I have an issue with this sheet and with other macros sheets as well. When I create the sheet its all fine but when I want to open it again, Microsoft automatically blocks the macros from running. Is there anything I can do about it. It happens even if its a macro enabled worksheet and I have enabled the macros by properties of the sheet.
I really appreciate your assistance! - Thanks so much Hans!
See the attached version. To view/edit the code, right-click the sheet tab and select View Code from the context menu.