Forum Discussion
Date of Last Modified for a Cell
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?
Here is a one drive link to an example of my problem: https://agcocorp-my.sharepoint.com/:f:/p/ben_thul/EiuK-sppvBlMi2tbpWm1lfsBY72MhvTbvKhOECo_QtZ_MA?e=XPRHi5
Thank you! This is the expected behavior: the formula will only set the time stamp if there is no time stamp yet and the order status is changed to a non-blank value. After that, the time stamp will remain the same until the order status is cleared.
If you want the time stamp to be updated each time the order status changes, you cannot use a formula. It can only be done using VBA code. There are several examples of such code in this discussion.
Digging up an old thread but I can't seem to get the VBA to run
Starting with A2, I would like to update column A with a date when anything in columns B through L is changed
Make sure that:
- The code is in the worksheet module (right-click the sheet tab and select View Code from the context menu to activate this module)
- You save the workbook as a macro-enabled workbook (*.xlsm)
- You allow macros when you open the workbook
