Solved

How to insert a last modified date and time into a cell when another cell in the row is modified?

Posted on 2014-11-11
3
113 Views
Last Modified: 2014-11-12
I have an excel spread sheet that has about 10 columns of data. I want to make a column named Last Modified. Then on each row, when a piece of data in one of the cells are changed, the Last Modified column will update with a new Date and Time.
0
Comment
Question by:klampo
  • 2
3 Comments
 

Author Comment

by:klampo
ID: 40435860
Here is an example.
Below is what I currently have.
excel1.pngNow assume that I made a change in Row 3, Last modified shows the date and time of the change. See the screenshot below with the parts highlighted yellow.
excel1changed.pngThat is what I am trying to accomplish. Each row has a cell that reports the date and time change of any cell in that row.
0
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40436132
Here is the code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:E43")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub
Me.Range("F" & Target.Row) = Date & " " & Time
End Sub

Open in new window

0
 

Author Closing Comment

by:klampo
ID: 40438764
Thank you, this solution met and exceeded my expectations.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Photo Albums in PowerPoint Photo Albums are a very useful tool in PowerPoint and allow you quickly add a large number of images. The images can be formatted in a variety of ways so that you are able to create a professional looking presentation v…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now