Excel update cell when another cell changes

Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. You can format the timestamp to other values of course:. The C column stores the value of A so that when A is changed, the formulas know that A has changed values.

The timestamp won't change if the user enters the 'dog' cell but leaves 'dog' as the value. And the timestamp of row 2 doesn't change when you change cell A in some other row, which is a problem of some excel solutions that capture timestamps.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 6 years, 11 months ago. Active 7 months ago. Viewed 7k times. Improve this question. RealHandy RealHandy 2 2 gold badges 7 7 silver badges 23 23 bronze badges. Add a comment. Any assistance would be greatly appreciated.

Warm Regards JT. Would the timestamp functionality be bypassed if the excel file you're using is a refreshable? Good day, The code does not support connections data.

Sorry for the inconvenience. Hello Everyone Thanks in advance for your help. What should be code to update the current time on the cell in column X if there is a change in any cell on that row? For example any change in values on cells a2 to w2, then the time should be to updated in x2. Thanks Again. Hi Crystal, this is really good, how can I get the timestamp change in each corresponding row when any cell from the range of cells in the respective row changes.

For example, A2 should get updated with timestamp when any changes are done on second row between B2 to H2 and similarly A3 gets the timestamp when changes done on B3 to H3, and so on until the last row. Adding the timestamp works very good and is very useful. However I receive an error when I delete a row, because the script cannot insert the timestamp in the row that does not exist anymore. Would be great if someone can advice how to solve this. Hi Sander, There is no error occur in my case.

Can you tell me your Excel version? Thank you for your comment. I have a project I'm working on that I update regularly. It's mostly just for keeping track of my employee's information like phone numbers, drivers license expiration, etc. Since I update it so frequently, I want an automatic timestamp that rests at the top or bottom of my worksheet that will update with today's date everytime I update information ANYWHERE on the spreadsheet.

I currently use A-N and so I need a stamp around M How would that code look? Open Developer and on your workbook select the Workbook and the BeforeSave event. In the sub put the code: Range "M40". Hi, Is it possible to alter the code so that any changes in multiple columns would generate a new timestamp in the same cell? I make an edit in anyone of cells A3, B3 or C3 and the timestamp updates just in C4?

Also, is it possible to make the code apply only to a specific range within a sheet? Hey, this is sort of similar to what I require, i'd like for a timestamp to be updated in column AG when cells between A and AH are updated. Hey, hopefully you still see this!!! I'm using the code below for a timestamp update in C6 anytime C5 is updated. The problem is that when I'm in the rest of the worksheet, anytime I hit enter or tab, it jumps me back to C5.

Any thoughts? Hi, This is exactly what I was looking for! However I was wondering if you can help me get it to work with a protected worksheet. It only seems to work on an unprotected one when the timestamp updates due to a change in value as part of a formula, similar to Dennis' request. Thank you so much! Hi, This can also work on a protected worksheet. You need to format the changed cells and the timestamp cells to unlocked status in advance before protecting the worksheet.

Please have a try again. Thanks for your comment. If it's changed due to a change in another cell and the value changes as part of a formula, there is no timestamp. Do you have a solution for this? Dear Dennis, The code has been updated with the problem solved. Hi, This works perfectly if I manually change the cell, when I copy and paste information is not working. I'm trying to have this timestamp every time someone pastes new information. Rather than changing cell information one by one, the behavior I want to capture is when the data is pasted in bulk for multiple cells.

Does somebody know what I should do? Thank you so much for this! I use scroll buttons to add 1 to my total every time I complete a task, but macros don't register changes to the buttons. After doing some more research I figured out how to assign a macro to my control buttons and now I can track my changes!!!!

I was making it more complicated than it need to be, this is what I ended up with: Sub Timestamp ' ' Timestamp Macro ' Timestamp on scroll buttons ' ' Range "j2". I've got a database in excel that I need to keep track of what has been changed.

Is it possible to modify the code so that if changes are made in sheet 1, it will duplicate the changed cell in sheet 2 and provide a time stamp beside it? Good day, Sorry can't help with that. Hi, can be done if any values are changed and the timestamp is updated only in a particular cell like A1.