Results 1 to 4 of 4

Inventory counting sheet and produce a packing list using barcode scanner.

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2021
    Posts
    63

    Inventory counting sheet and produce a packing list using barcode scanner.

    Hello everyone,

    so I have the attached packing/Counting list
    I use a barcode scanner to count the products (one by one) and have the information of them on the sheet named "assortment" as shown. I do this manually, unfortunately!
    is there any chance to have the "assortment" sheet automated by formulas? only with scanning the barcodes at sheet named "Reader" in columns "Item Barcode READER" and "Box Barcode READER"? and the others will be automatically read?

    I'd really appreciate it if you can help me with this and teach me how to do it

    Thanks in advance.

    Cheers.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Inventory Mangement - Barcode Scanner
    By NewYears1978 in forum Excel General
    Replies: 13
    Last Post: 09-30-2020, 12:57 AM
  2. Replies: 5
    Last Post: 12-31-2019, 02:27 PM
  3. Replies: 4
    Last Post: 08-25-2017, 01:39 PM
  4. Replies: 0
    Last Post: 03-17-2017, 10:52 AM
  5. Can Excel be used with a barcode scanner to track inventory?
    By polluxtroy12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2013, 09:43 PM
  6. Trying to track inventory using a barcode scanner in Excel
    By ernht38 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 08:16 AM
  7. Using a barcode scanner and UPC master sheet for Inventory Control
    By jlucas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2011, 04:03 PM

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