Auto insert date/time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Cells which contain NOW will recalculate automatically whenever the workbook
is recalculated.

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

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
The next Grand Theft Auto title has been officially announced 0
Whats wrong with this function? 5
Trigger a Date & Time stamp by entering data in another field... 4
Automatically insert date 2
Excel Auto Filter Problem 2
25th percentile (cycle time) 3

Back
Top