Ask Your Question

Need to limit columns to two and go from A1 to B1 "enter" A2 to B2

asked 2019-05-03 00:56:47 +0100

scottisaac123 gravatar image

updated 2020-10-25 18:49:40 +0100

Alex Kemp gravatar image

I need to set up a spread sheet for scanning purposes. What I want to happen: I scan my part number and it gets entered into cell A1, active cell moves to B1 then I scan my serial number and the active cell moves to A2 ready for the next part number and serial number. And it repeats after that. A2 -> B2, A3 -> B3.

Thanks for the help!

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-05-03 17:00:53 +0100

Jim K gravatar image

Starting in cell A1, press Tab to go to the next cell in the same row, cell B1.

Then press Enter to go to the beginning of the next row, cell A2.

edit flag offensive delete link more


I should have added, I would prefer to not have to use the keyboard at all. Is there a way to set it to only use TAB for column A and only use ENTER for column B?

scottisaac123 gravatar imagescottisaac123 ( 2019-05-03 17:30:25 +0100 )edit

answered 2019-05-04 17:36:12 +0100

Cookievore gravatar image

I had to try a few things but finally found a way. Not smart, but it would work. You can do this with Base. I'll add a very simple prototype. The .odb file is LO Base and db type is HSQLDB. Field SN is the primary key. With a Laser Barcode Scanner type MK-1500 I'm able to scan barcodes endless forward that way you are looking for. At least in Windows 7, because my Scanner is not functional under Windows 10 (should, but isn't).

Once this is done, there seems to be only one real tiny path to export a table from Base to Calc via Clipboard (found no other export option). But there is a drawback of how numbers are recognised when inserting into Calc: Right-Click the table in Base, copy, move to Calc, Right-Click cell, (don't know exact in english) Insert contents, on fly-out again Insert contents, choose HyperText Markup. This inserts the data as text. Other options would result in number conversion and displaying them in scientific notation. From Calc you could export again into other data formats.

Maybe you have to figure out some more details until your workflow is operational. Good luck.

C:\fakepath\Auto PN SN Scan.odb

C:\fakepath\Auto PN SN Scan.ods

edit flag offensive delete link more

answered 2019-05-04 19:06:56 +0100

Lupp gravatar image

Can you configure your scanner to send a HT (code 09) as the delimiter? If so you can remove cell protection from the range A:B and then protect the sheet. Any HT will then move the focus to the next unprotected cell, and thus, if starting with A1 to B1 -> A2 -> B2 and so on.. (Not having your or any scanner at hand I couldn't test.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-03 00:56:47 +0100

Seen: 151 times

Last updated: May 04 '19