Datestamps in Excel when any value changes in a range of cells

Hi @Magill, Shawn,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, you want to have the Last Modification Date & Time data when any value in any cells within row 2A to 2N have changes. Your request can be achieved by using Excel VBA. You can try using the VBA script provided by Q&A Assist in the previous reply. That script will return the modification time value whenever a cell in row A2:N2 having data changed, other changes in any cells except from row A2:N2 won't affect the modification time. The only thing you need to change is the cell that you want to place the modification. For example, if I want to put it in cell A7 instead of cell O2, it would be like this:

Just in case that if your goal is to export the last changed time of data in row A2:N2 in the past (for example file is saved yesterday, today you want to return A2:N2 modification time), unfortunately there is no built-in option in Excel to achieve that. Excel does not keep a per-cell/row edit history so you cannot find out what time A2:N2 last changed unless you already export the time when the change occurred (same as using the above VBA script).

I hope this information is helpful. You can try the script and let me know if it works for you. If not, we can work together to resolve this.    

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you. 

I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.