Static time upon data entry

[lakaihigh]

So, currently I'm using the now() function to pull current time based upon a data entry in another cell. Ex:=IF (a1>1, now()). I need the time to be static instead of volatile however and not update upon new data entry in the sheet. How would I go about writing that in vba to automatically put the time in when a1 >1, and a2 > 1 etc. Any help would be greatly appreciated.

 

[sandy666]

maybe adapt timestamp in B2: =IF(A2="","",IF(B2="",NOW(),B2))
if you add something in A2 then you will get date and time in B2 "frozen"
iterative calculation must be enabled. Options - Formulas - Enable iterative calculation
adjust references

 

[lakaihigh]

Thank you so much, a circular formula didnt even cross my mind. Appreciate it, works like a charm.

 

[sandy666]

You are welcome

Have a nice day