Auto insert date/time

T

Tino

I need to auto insert date/time in column A when an area is picked from
pulldown in column B. I have this: =IF(COUNTA(B45)<>0,NOW(),"") it works but
it updates all previous in column A.
 
D

Dave F

Cells which contain NOW will recalculate automatically whenever the workbook
is recalculated.

Dave
 
Top