+ Reply to Thread
Results 1 to 6 of 6

Barcode Scanner Data Input

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Brighton
    MS-Off Ver
    2010
    Posts
    3

    Barcode Scanner Data Input

    Hi there!

    We have recently bought a USB barcode scanner (HX-US500) with the intention to be able to dispatch our orders quickly using Excel to populate the data.

    For certain orders that are sent via a tracked service, we need to acquire the tracking details from the Royal Mail/Courier label. To save having multiple sheets for different dispatch types we would like to create a spreadsheet that can hold all the data for us. We would need the data to be entered in just two columns and to be populated as A1, B1 then A2, B2, A3, B3 and so on. Currently the scanner is set up to "enter" so is running A1 A2 A3 A4 etc. Unfortunately the manual it came with does not have a set up for the barcode to "tab" rather than "enter" and I cannot find any online manuals for this either.

    I am sure that the answer is very simple, but not being an excel genius I need a little help setting this up!

    Also, if anyone happens to know how to create a barcode with no data just a blank cell, or even a "N/A" barcode we'd love to know! (barcode novices!)

    Thank you for your help in advance.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: Barcode Scanner Data Input

    Hi, and welcome to the forum.

    If you'd like to upload a workbook with some typical inputs from your scanner I'll take a look. I recently wrote an application for a client which featured scanned bar codes and I suspect all you need to do is to either have some pre-processing macro as each code is scanned, or possibly allow the data to come into a temporary holding sheet and then periodically run a macro to parse the data and put it into two columns.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-15-2014
    Location
    Brighton
    MS-Off Ver
    2010
    Posts
    3

    Re: Barcode Scanner Data Input

    Hi Richard

    Thank you for your very speedy response!

    I have attached an example of the very simple spreadsheet that we would be looking for. The first sheet shows how we would like it to look. The second sheet is how it is actually coming though. In time we may want to add another scanner so that we could have separate sheets for each dispatcher, do you think that excel would work with that too?

    Look forward to hearing from you!
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: Barcode Scanner Data Input

    Hi,

    The attached is one way with a macro.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-15-2014
    Location
    Brighton
    MS-Off Ver
    2010
    Posts
    3

    Re: Barcode Scanner Data Input

    Thanks Richard, that's great! We will have a play with this then, and fingers crossed it'll work well1 Appreciate your help with this!

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: Barcode Scanner Data Input

    My pleasure. Thanks for the rep.

+ 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. [SOLVED] Using a Barcode Scanner to Input Data Into Excel
    By sjftcec in forum Excel General
    Replies: 7
    Last Post: 08-29-2019, 03:28 PM
  2. Vlidating barcode scanner data entry in a text box, by If function
    By sdavardoost in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2012, 11:41 AM
  3. Barcode Scanner
    By Rockhead_67 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-14-2011, 03:29 PM
  4. Searching database with barcode scanner input
    By IDer in forum Excel General
    Replies: 1
    Last Post: 12-10-2009, 11:31 AM
  5. download data from Barcode scanner thru serial port??
    By d61helix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2005, 10:41 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