goes to next row if....

[Norbac]

I am using barcodes to insert information about the product that we do, ( please see picture of spreadsheet attached )

my problem is where I scan the information of the people who worked in a certain job.

If I want to go to the next field (goes to ), I would have to scan the barcode of 8 operators, but the number of operators varies from job to job, it is not always 8.

I would like for example that if I only have to put 4 operators I would have a barcode with some word for example "End"
and that when scanning that barcode it will "jump" to the next field ( goes to )

the way it's working right now is that after scanning a bar code it moves to the right... I locked the other cells makes it move to the next field, but obviously the problem is that I have 8 cells in the operator field

I thank you in advance for any help you can offer me.

 

[vletm]

Norbac
#1 Have You tested to scan 'nothing' - I mean scan 'air'?
I haven't test myself - do it give empty or what?
#2 Could You add a button to Your given ejemplo.PNG?
... which gives needed information that no more scanning.
#3 It would be better to send a sample Excel-file than some snapshots.