Link to home
Start Free TrialLog in
Avatar of klampo
klampo

asked on

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

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.
Avatar of klampo
klampo

ASKER

Here is an example.
Below is what I currently have.
User generated imageNow 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.
User generated imageThat 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.
ASKER CERTIFIED SOLUTION
Avatar of Haris Dulic
Haris Dulic
Flag of Austria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of klampo

ASKER

Thank you, this solution met and exceeded my expectations.