Date Stamp on Excel using barcode Scanner

We have a very simple need. There are 2 columns Coulmn A = Order No Column B = Date Dispatched The values in the column A will be inserted manually by ourself. The only function that we need is the date dispatch column. We need the column A to be the database. So in column B we need it to be filled with the date when the order is being shipped. But we need this by using the barcode scanner. FOr example: Let say in coulmn A there is one order with no. 1000094232 (this one is being inserted manually beforehand) So when the barcode scanner is scanning the papaer invoice with order no 1000094232. The column B will try to find the matching row in column A with the same order no. And it will insert todays date (no need time). Please find the related excel files down here