How to Move Barcode Scanner to Next Row in Excel (2 Ways)

Barcode scanners are devices that receive, interpret, and send data from barcodes. It serves a really simple purpose. Barcode scanners, although they may appear straightforward, are actually quite helpful for any company. Microsoft Excel has a useful function that allows you to save barcodes in individual cells. In this article, we will demonstrate how to move the barcode scanner to the next row in excel.


Download Practice Workbook

You can download the workbook and practice with them.


2 Effective Ways to Move Barcode Scanner to Next Row in Excel

Utilizing a sequence that a system can read, barcodes are utilized to encrypt data. Barcodes can monitor items, costs, and inventory levels enabling central recordkeeping in computerized software products, among other things. While working with barcodes it does not move to the next row properly in Excel. So let’s look at the ways to move the barcode scanner to the next row in excel.

barcode scanner excel move next row


1. Utilize Excel Options to Shift Barcode Scanner to Next Row

Using data from a range of cells as input, a formula in Excel performs an operation. These equations nonetheless provide a result, even if it’s erroneous. With the use of Excel formulas, we can execute operations like addition, subtraction, multiplication, and division. Also with an excel formula, we can input the barcode. Let’s follow the instructions to do this.

STEPS:

  • Firstly, go to the File tab from the ribbon.

barcode scanner excel move next row

  • This will take you to the backstage menubar of the excel file.
  • Secondly, scroll down a bit and click on the Options menu.

  • Thus the Excel Options dialog box will appear.
  • Now, go to the Advanced option.
  • In the Editing Options group, check mark After pressing Enter, move selection.
  • And select the direction Down from the Direction drop-down menu.
  • Further press the OK button to complete the process.

  • Then, select the next row where the barcode is located, to move the barcode. In our case, we select cell C5.
  • After that, write down the formula for that cell.
="("&C4&")"
  • Furthermore, press the Enter key from your keyboard.

  • Go to the Home tab from the ribbon, and make sure you are selecting the cell.
  • Subsequently, under the Font category, select the font IDAutomationHC39M.
Note: If you do not have that font in excel, download the font. This font is available in Google.

  • Finally, you can see that the barcode scanner moves to the next row of the code.

barcode scanner excel move next row

Read More: How to Add Barcode Font in Excel (Installation and Application)


2. Apply Excel VBA to Move Barcode Scanner to Next Row

With Excel VBA, users can easily use the code which acts as an excel menu from the ribbon. Let’s follow the procedure to use the VBA code to move the barcode scanner to the next row.

STEPS:

  • Firstly, go to the Developer tab from the ribbon.
  • Secondly, click on Visual Basic from the Code category to open the Visual Basic Editor. Or press Alt + F11 to open the Visual Basic Editor.

  • Instead of doing this, you can just right-click on your worksheet and go to View Code. This will also take you to Visual Basic Editor.

  • And, this will open up the visual basic window.
  • After that, copy and paste the VBA code below.

VBA Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 Then
        Target.Offset(0, 1).Select
    ElseIf Target.Column = 3 Then
        Target.Offset(1, -1).Select
    End If
End Sub
  • After that, save the code by pressing the Ctrl + S key from your keyboard.

Code Explanation

Private Sub Worksheet_Change(ByVal Target As Range)

Sub is a part of code that is used to handle the work in the code but will not return any value. It is also known as subprocedure. So we name our procedure

If Target.Column = 3 Then
Target.Offset(0, 1).Select
ElseIf Target.Column = 3 Then
Target.Offset(1, -1).Select
End If

Start by moving from cell C4  to cell C5 and selecting cell C4 using the If Else statement and Offset property. Finally, go to the following line in the C5 cell by using the Offset attribute.

End Sub

This will end the procedure.

Note: You don’t need to change the code. All you can do is just change the range as per your requirements.
  • The barcode may then be moved by selecting the subsequent row where it is situated. In this instance, we choose cell C5.
  • Write the formula into that cell after that.
="("&C4&")"
  • Press the Enter key on your keyboard once more.

  • Make sure you choose the cell when you go to the Home tab on the ribbon.
  • Likewise, in the previous method, select the font IDAutomationHC39M from the Font category after that.
  • The barcode scanner finally moved to the following row of the code, as you can see.

barcode scanner excel move next row

Read More: [Solved] Barcode Scanner Not Going to Next Line in Excel


Things to Remember

  • Our ideas aren’t appropriate for our purpose or location, the scanner isn’t working correctly, or our equipment isn’t matched to barcodes.
  • A start, stop, or check digit that is absent or entered incorrectly is the most frequent reason for a barcode typeface to refuse to scan.
  • A unique start character, termination personality and the majority of barcode typefaces also call for a computed check digit. Verify that the barcode fonts are being printed in the appropriate format.

Conclusion

The above ways will assist you to Move Barcode Scanner to Next Row in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback. Or you can glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo