need to post date when a cell is not blank, suggestions?
Posted by Daniel P. on January 03, 2001 5:48 AM
I'm working with a data capture tool (used every 15 minutes) and would like to post a date/time with each entry without typing it. I thought about using...
(For cell A1)
=IF(NOT(ISBLANK(A2)),NOW(),"")
This would work fine if it would post the date and never update. Is there a formula that will do this?
Posted by marbel on January 03, 2001 7:34 AM
That formula should work well, but use it off sheet, and then use a quick copy / paste-special-values macro. Just record your actions of copy / paste special and choose values in the destination sheet.
