+ Reply to Thread
Results 1 to 2 of 2

Easy Bar Code Scanning

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Grayson, KY
    MS-Off Ver
    2007
    Posts
    1

    Easy Bar Code Scanning

    I have a Point of Sale system that I am trying to find a good way to make .CSV files for to reconcile inventory counts. Basically all that is required is a .CSV file with the UPC barcode of an item in the first column, and the Qty on hand in the 2nd column. I am using a standard USB barcode scanner. When you scan something, it quickly inputs the number, and then presses ENTER. What I would like for excel to do, for example, is move from cell A2 to cell B3 on enter, then move from B3 to A4 on enter, and repeat these steps to make the workflow simple. This would mean that you are working your way down the columns scanning the code, inputting the QTY then pressing enter, repeat. Is there a way to do this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Easy Bar Code Scanning

    Perhaps follow these other 2 (related?) threads?
    http://www.excelforum.com/showthread.php?t=1167866
    http://www.excelforum.com/showthread.php?t=1170181
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Scanning a bar code int o speadsheet
    By soupergeek in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-18-2015, 11:15 AM
  2. How to add up quantity automatically by scanning product code?
    By sheiling in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-01-2013, 06:21 AM
  3. Bar Code Scanning - Check a Box and Hit Compete Button
    By JackieBP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2012, 12:50 PM
  4. Excel 2007 : Cursor Movement after Scanning a Bar Code
    By KERNELJEFF in forum Excel General
    Replies: 4
    Last Post: 12-16-2011, 04:55 PM
  5. Bar code scanning
    By joshag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2011, 05:19 AM
  6. Bar Code Scanning
    By Smileycam in forum Excel General
    Replies: 1
    Last Post: 07-04-2006, 10:25 PM
  7. [SOLVED] Scanning Code
    By Adept in forum Excel General
    Replies: 1
    Last Post: 04-09-2006, 07:50 AM

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