Forum Discussion
Date of Last Modified for a Cell
In the formula in my first reply, A2 is the cell you want to track and A3 is the cell with the tine stamp.
If you cannot get it to work: could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
See attached the sheet.
Another issue is that if one cell updates with the date then all cells update.
https://1drv.ms/x/s!Avzs3jKduffg1hpOPBFgykz9_O0n?e=7a4cPA
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.
- 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!
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.