Create a 2 column sheet that moves the selected cell along then down when filled

[R11989]

Hi,

I'm trying to create a 2 column sheet that will be populated by barcodes, which will be scanned into a tablet via a barcode scanner. Each product has our own SKU barcode and a branded barcode (GTIN), I need to capture both on the same row for hundreds of products with minimal effort from the user.

Ideally, what I would like it to do is this:

The user will scan a SKU barcode into cell A1, the selected cell should then move to B1 where the GTIN code can be scanned. Once those 2 are filled, I'd like the selected cell to move to A2, then B2, then A3->B3->A4->B4 and so on, allowing the user to capture both codes without having to press anything to move the cell down and across for the next product.

It sounds fairly simple to my mind, but I'm not getting anywhere with it, so I'm posting here in the hope that someone has done something similar in the past and has some advice.

Many thanks.

 

[Kaper]

You probably need to take 3 actions to achieve the reult.
1) select two columns where your data will be scanned into and select formatting cells (Ctrl+1) and uncheck Locked (by default it is checked)
2) Protect the sheet and allow user only to select unlocked cells (by default both locked and unlocked cells are allowed
3) in options go to advanced and select Right (Down is defaullt value) as direction after pressing Enter as the scannner button probably sends the scanned code and equivalent to Enter key to the cell. If not - check the scanner settings.

 

[R11989]

You probably need to take 3 actions to achieve the reult.
1) select two columns where your data will be scanned into and select formatting cells (Ctrl+1) and uncheck Locked (by default it is checked)
2) Protect the sheet and allow user only to select unlocked cells (by default both locked and unlocked cells are allowed
3) in options go to advanced and select Right (Down is defaullt value) as direction after pressing Enter as the scannner button probably sends the scanned code and equivalent to Enter key to the cell. If not - check the scanner settings.

Hi Kaper,

thanks so much for your reply, the solution works perfectly on my windows version of excel, but annoyingly, not when I use it on the tablet. I can't see the options menu anywhere in excel (for android) so I am assuming the option just isn't available at all and android Excel doesn't know to do this or the code just doesn't exist for this option. Very annoying!

I will keep playing around with it and see if I can find a solution anywhere, but thanks again for your help. I have a wireless scanner, so I am wondering if I could just connect it to a laptop instead of the tablet, which will definitely work.

So thanks again, I really appreciate your help.

Ben