Scan It to Office Barcodes

[Vx94]

Hello,

Been getting a document together for barcodes, everything is going okay so far except getting the barcode scanner to figure out which row the correct barcode is on before inserting the information inputted. As I'm using Scan it to Office and what I have figured and can do so far is scan, it'll enter what it needs to then it goes to the next row so one would need to scan in order each and every time.

I am not yet fluent in Java Script nor much other code, but slowly I'm starting to understand a few things and how todo it.
Could this be done? And what method would be the simplest?

Thank you.