Barcode scanner: After scanning specific code move mouse to the specific column

[danfolt]

Hello, does exists some function which will take me to the specific cell( column) after scanning a barcode which I will create and use only for that purpose ? I have a workbook which I want to use for a simple beverage inventory of 5 nightclubs ,
feeding barcode columns are (every column represents a different club):

1.club - column A
2.club - column J
3.club - column S
4.club - column AB
5.club - column AK

I would like to create UPS barcode which after the scan will give me number (for example) 11111, this number should represent function which will take the mouse to the specific cell, or column, let say that I want to insert many beverages in club 2 so I want to move the mouse to column J , cell 3 and after that I will continue scanning bottles and inserting them in that column, is this possible?
In a few words I want to know if I can use the scanner also for skipping to specific cells (columns) , I would like to avoid using the mouse and keyboard as much as possible. I attach the file here: inventory-nightclubs-test.xlsx . Thanks

[saulbishop]

With keyboard, I know how to generate barcode in specific cells. But when it comes to the barcode reader, I have no idea. Now I am trying to figure out how to achieve this that when using barcode reader , data insert A1 to A12 automatucally. So if you find some answers, please share with us.

[sdfsfewew]

When talking about barcode readers, I know a good site. It provides various barcode readers, like Excel barcode reader, Java barcode reader, etc. I used their Java barcode reader SDK and Java barcode generator SDK. They are good to use.

[danny rough]

to create barcode with keyboard, i think you should employ a barcode reader which contains such functions. as for how to create it in specific cells, i think you can follow the steps provided , make it as reference, i think you can get it , good luck!

[FDibbins]

perhaps you need to keep an eye on this thread?

http://www.excelforum.com/excel-prog...ns-finish.html

[beverlydaddzie]

With keyboard, I know how to generate barcode in specific cells. But when it comes to the barcode reader, I have no idea. Now I am trying to figure out how to achieve this that when using barcode reader , data insert A1 to A12 automatucally. So if you find some answers, please share with us.

Hi, have you figured out how to do that? Doing it one by one is so annoying and timewasting. It'll much easier and timesaving if it can be done automatically.