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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, this solution met and exceeded my expectations.
ASKER
Below is what I currently have.
Now 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.
That 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.