Scan barcode to excel with date & time stamp in & out

[nty8baby]

Hi All,

I have similar questions to below trackback but the format is difference. I wanted below item to be scan and date and time appear on a different column. For Example

Scan in A3, date and time appear in A3 for item taken out.
Scan in F3, date and time appear in H3 for item return.

I tried changing the Macro by adding another cell but of course it did not work out. Can you please help me out?

 

[mrmmickle1]

I don't see what "trackback" or thread your referencing. There's not a link.