+ Reply to Thread
Results 1 to 2 of 2

Barcode Scanner help

  1. #1
    Registered User
    Join Date
    02-22-2021
    Location
    birmingham
    MS-Off Ver
    office 365 for enterprise
    Posts
    1

    Post Barcode Scanner help

    Hi, hope you're all well

    I need some help with scanning a barcode into excel and the fields filtering correctely.The barcode scanner i use is a Honeywell 1400g
    This is the headings i need -
    GTIN barcode data - example 05060534754683
    Expiry Date - example 2025-10
    Lot Number - example 1234567 89
    Product information - name of product

    When i scan the barcode the data doesnt fill the fields out correctely, how do i do that?
    Thanks,
    Ben

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,550

    Re: Barcode Scanner help

    .
    Use the barcode to fill a cell.

    Do a VLOOKUP (of the barcode data) in your database of all barcodes (usually a different workbook sheet).

    When located, copy that row of data into the appropriate fields.

    You can perform the VLOOKUP one of two ways :

    #1: place your VLOOKUP code in the Worksheet Change event so it automatically searches.

    #2: place your VLOOKUP code in a separate macro that is activated via a command button. Click the command button to perform the search.


    There are plenty of examples from others on this Forum and others ... as well as on the internet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 03-17-2017, 10:52 AM
  2. Barcode scanner help
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2016, 05:43 AM
  3. VBA Keylogger for barcode scanner
    By bgrillob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2014, 11:32 AM
  4. Using a barcode scanner with excel
    By Fred45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2013, 09:23 AM
  5. Barcode scanner in excel
    By amir8000 in forum Excel General
    Replies: 1
    Last Post: 06-03-2013, 08:30 PM
  6. barcode scanner
    By metallicadad38 in forum Excel General
    Replies: 1
    Last Post: 11-09-2012, 04:55 AM
  7. Barcode Scanner
    By Rockhead_67 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-14-2011, 03:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1