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
121 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

In a nutshell Dropbox is a cloud-based data storage service which synchronizes with data files on your computers. The Dropbox folk provide 2GB of free storage but if you need more you can sign up for a 50GB or 100GB subscription account. I pr…
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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 …

777 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