The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.įrom now on, when changing data in column C, the timestamp will be populated into corresponding cells in column E as below screenshot shown. Please change them based on your needs.ģ. Note: In the code, number 3 means that you are going to modify data in column C, and 5 indicates the timestamp will be populated into column E. VBA code: Insert current timestamp when data in another cell changes Private Sub Worksheet_Change(ByVal Target As Range) Then copy and paste the below VBA code into the Code window of the Microsoft Visual Basic for Applications window. In the worksheet you need to modify and mark with timestamp, right click the sheet tab and then click View Code from the right-clicking menu.Ģ. Insert current timestamp when data in another cell changes with VBA codeĪs below screenshot shown, you need to populate timestamp in column E if corresponding cells in column C are changed. How to deal with it? This article will show you method of inserting current timestamp when data in another cell changes in Excel as below screenshot shown. And after modifying the worksheet, you need to insert the modified timestamp to let others know which cells have been changed. Supposing you receive a worksheet which needs you to modify data in a certain column. How to insert current timestamp when data in another cell changes in Excel?
0 Comments
Leave a Reply. |