Thread: Auto insert date/time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tino Tino is offline
external usenet poster
  
Posts: 4
Default Auto insert date/time
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.
Reply With QuoteReply With Quote