Sleeper: Scan barcode to two documents at the same time

[toradoya]

Good Day,,


i need to scan barcode to two documents at the same time


i created 2 Excel workbooks the first one is : Daily Record and the second is : Invoice Record


what i want to do is : when i scan a barcode to a specific column in the first workbook ,
the barcode No. will also goes/auto copy to specific column in the second workbook.


Please Help i need an idea on how to do this, also i attached the 2 files