LinkBack URL
About LinkBacks
Hi all,
I'm trying to add a timestamp on the end of each row that will show the latest date/time that any of the cells in that row have been changed.
Please see sample. sample.xlsx
Hi all,
I'm trying to add a timestamp on the end of each row that will show the latest date/time that any of the cells in that row have been changed.
Please see sample. sample.xlsx
Last edited by ld2x07; 06-14-2013 at 11:20 AM.
Add the following code below to the worksheet module and format the cells in column T to the desired format.
Save the workbook as .XLSM
Adjust the range in the code to the range needed
HTML Code:
And a formula suggestion...
=IF(COUNTA(B3:S3)=0,"",IF(T3="",NOW(),T3))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi, Fotis
This formula =IF(COUNTA(B3:S3)=0,"",IF(T3="",NOW(),T3)) is not valid because of a circular reference.
Try and put any value in range mentioned B3:S3 and see.
Duplicate post.
Last edited by Indi_Ra; 06-14-2013 at 08:20 AM. Reason: Duplicate post.
@ Fotis
Yes, I knew the formula [=IF(A1="","",IF(B1="",NOW(),B1)))], but you had explained that "The formula works only if you have enabled iterative calculation mode"
Indi_Ra you're a star (and i'm a poet)
Just what I was looking for!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks