BARCODE SCANNER INPUT EXCEL

Question

Hi everybody,

Hope you're safe and healthy.

I'm using a Barcode Scanner for work, and I wanted to know if it is possible to make him follow a certain order when it insert the data in my excel sheet.

There are 2 types of data that I want it to scan:

• Serial Number
• Quantity

Is it possible to make the scanner insert the data in the following order A1,B1,A2,B2,A3,B3 (as you can find below)?

A1	B1
A2	B2
A3	B3

Thanks in advance for any response,

Alex Barbosa

Answer 1

As you can see in the following doc:

https://we.tl/t-plHxtcdPYV

When I put my pointer in the O5 cell (wich is the 1st that I want to fill), it forces me to go up right to P4 cell...

You can't and there is no need to do so.

Select the "QTD" cell, press F2, press ENTER. The code jumps into P5 and now start your scanning process.

Andreas.

Answer 2

The only issue that i'm getting is that the input is made vertically (A1,A2,A3,ETC...) and I need it to be made in this order (A1,B1,A2,B2,A3,C3, ETC..)

If possible, I would like to avoid VBA

No chance.

Be sure your macros are enabled. Here is the article how to enable:

Change macro security settings in Excel - Excel

Right-click on the sheet tab
Choose "View Code"
Paste in the code below
Close the VBA editor

Before you copy the code below into your file please read this article:
VBA issues with new forum editor - Microsoft Community

Andreas.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  Application.EnableEvents = False

  On Error GoTo ExitPoint

  Select Case Target.Column

    Case 1

      With Target.Offset(-1, 1)

        If IsEmpty(.Value) Then .Select

      End With

    Case 2

      With Target.Offset(, -1)

        If IsEmpty(.Value) Then .Select

      End With

  End Select

ExitPoint:

  Application.EnableEvents = True

End Sub

Answer 3

Hi Jeovany and Andreas,

Thanks for both answers, I highly apreciate the time you're dedicating to me.

All the information is displayed in barcodes, Serial Number, and Quantity too.

The only issue that i'm getting is that the input is made vertically (A1,A2,A3,ETC...) and I need it to be made in this order (A1,B1,A2,B2,A3,C3, ETC..) so that the quantity is specified in front of the Serial Number and not below.

If possible, I would like to avoid VBA (as I never worked with it) but if not possible, that could be a solution.

Regards,

Alex Barbosa

Answer 4

Hi Alex

You mentioned

To want to scan 

Serial numbers and quantity 

The first is common when you scan a barcode it will show in the cell the corresponding serial number 

The second scan the quantity ??????

Quantities not commonly shown in barcodes.

Please clarify it

Regards

Answer 5

Which order is he currently following?

If the cell changes after a scan we can use VBA and select the next cell of your order.

Andreas.