LinkBack URL
About LinkBacks
Best way is to use vba as Moo has given you.
another option aside from the given two is creating a circular reference.And enabling Iteration.
say date/time will be in B1 down.
in B1 =IF(A1<>"",IF(B1="",NOW(),B1),"") -fill formula down down.
Best way is to use vba as Moo has given you.
another option aside from the given two is creating a circular reference.And enabling Iteration.
say date/time will be in B1 down.
in B1 =IF(A1<>"",IF(B1="",NOW(),B1),"") -fill formula down down.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks