Hi everyone,

I was hoping someone could offer some assistance to a problem i can't solve myself.

Basically i have the following:
Wireless barcode scanner
Spreadsheet with 3 columns (Asset Number, Status, Time/Date)
Asset number barcodes
'Check In' or 'Check Out' barcode

What i would like to happen:
Using the wireless barcode scanner i scan an items asset number that gets entered into the first cell
Then i scan a second barcode either the Check In or Check Out code depending on wether the asset is been checked in or out and this gets entered into the second cell
The 3rd cell automatically populates the current time and date
Moves to the next row

Any help on this would be greatly appreciated.