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
124 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

696 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