Date and Time

[mmoore2895]

I have spreadsheet that barcode numbers are scanned into. I would lik
to set it up where when the number is scanned into the cell that th
date and time are automatically entered into the cells to the right
I'm pretty good with functions, formulas, and macros and such, but
can't seem to figure this one out. Anyone have any ideas

 

[vtisix]

First, you have to turn on Iteration in Tools > Options. If data is
scanned into cell A1, try formula:

=if(isblank(A1),"",if(B1="",Now(),B1))

 

[mmoore2895]

I've tried =if(isblank(A1),"",if(B1="",Now(),B1)) before and the proble
with it is the "Now" makes the date time continually update. I need th
date and time to be entered and stay that same date and time. I did
Macro where you can run the macro and it inserts a date and time tha
does not continually update by using Control + ; and Control + Shift
; Is there a way to do a formula that will run the macro when the dat
is scanned into the first cell

 

[vtisix]

Try:
=if(isblank(A1)," ",if(B1=" ",Now(),B1))

Notice the extra spaces between " ".

 

[mmoore2895]

THANKS!