I need help in excel for barcode scanning?

I need help in excel for barcode scanning?

I use excel to scan in inventory starting with the product number then the serial number. Instead of all the barcodes being scanned into one column, I want to know if there is a way to get excel to take the first scanned item and assign it to one column and take the next item and assign it to the next column.

For example Instead of scanning this way

product 1
serial 1
product 2
serial 2
product 3
serial 3

I would like excel to scan this way
product 1 serial 1
product 2 serial 2
product 3 serial 3

Tags: , , , ,

Under Forum

2 Comments for I need help in excel for barcode scanning?

  • 1. Colanth  |  February 15th, 2011 at 9:04 am

    Excel sees the barcode scan as input from the keyboard with an “Enter” at the end. I don’t know of any way to tell Excel to accept “Enter” to mean “move to the next column”. Maybe if you wrote some VBA code? Or ask on http://www.mrexcel.com/forum/index.php (there are some real Excel gurus there).

    If not, fill the column, copy the column and Paste Special/Transpose.

  • 2. garbo7441  |  February 15th, 2011 at 9:44 am

    The easiest thing to do would be to scan in your data, then when finished run the following macro. This example assumes the data is scanned into column A.

    If your column is not column A, change all “A” references to your column letter, i.e. “M”, “S”, etc.

    Change the “B” reference to the column letter you wish to relocate the serial numbers to, i.e. “N”, “T”, etc.

    Then copy the macro to the clipboard:

    Sub RepositionData()
    Dim i, LastRow
    LastRow = Range(“A” & Rows.Count).End(xlUp).Row
    For i = LastRow To 1 Step -1
    If Cells(i, “A”).Row <> 1 And Cells(i, “A”).Row Mod 2 = 0 Then
    Cells(i – 1, “B”).Value = Cells(i, “A”).Value
    Cells(i, “A”).EntireRow.Delete
    End If
    Next
    End Sub

    Press ALT+ F11

    In the menus at the top of the VBE, select INSERT > MODULE

    Paste the macro into the editing area to the right.

    Close the VBE and return to the worksheet.

    Press ALT + F8

    When the Macros window opens, select the macro and click ‘RUN’.

Leave a Comment for I need help in excel for barcode scanning?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories