+ Reply to Thread
Results 1 to 3 of 3

Barcode scanner and excel data input

  1. #1
    Registered User
    Join Date
    11-11-2020
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    1

    Barcode scanner and excel data input

    Hi guys,

    I dont know if anyone has faced the same situation as me but I am trying to minimize the time I am spending to check my receiving order by using the barcode scanner and an excel invoice (with UPC, SKU, Description, QTY order) as attached.

    Right now every time I scan the box only UPC code show per line per scan and I have to manually sort and add up and put in correct description.

    Is there any way that I can use barcode scanner to scan the Upc in the item and they will auto look up and add on right in the QTY RC line in my excel attachment?

    Please kindly help if you know some solution for this.

    Really appreciate your help.

    Thank you all
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: Barcode scanner and excel data input

    How about VLOOKUP?
    With a cell contains UPS, VLOOKUP that cell within table then returns value in given column.
    Quang PT

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

    Re: Barcode scanner and excel data input

    .
    Here is one resource : https://www.excelforum.com/excel-gen...e-scanner.html

    I did a search on this Forum using "scanner inventory".

+ 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: 5
    Last Post: 12-31-2019, 02:27 PM
  2. [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
  3. Detecting Barcode Scanner input vs input by hand
    By Dave2018 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2018, 01:20 AM
  4. [SOLVED] Barcode scanner to Excel
    By codrinelu in forum Excel General
    Replies: 47
    Last Post: 05-17-2016, 11:06 AM
  5. Barcode Scanner Data Input
    By mcnicolh in forum Excel General
    Replies: 5
    Last Post: 10-15-2014, 10:27 AM
  6. Barcode scanner in excel
    By amir8000 in forum Excel General
    Replies: 1
    Last Post: 06-03-2013, 08:30 PM
  7. Searching database with barcode scanner input
    By IDer in forum Excel General
    Replies: 1
    Last Post: 12-10-2009, 11:31 AM

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