+ Reply to Thread
Results 1 to 4 of 4

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

  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

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

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

    try this one
    but how to caalculate Number of pieces?
    and how to split
    1201-950328-01-54682 LGHT GREY MELANGE -S
    1201-950328-01 / 54682 / LGHT GREY MELANGE /S
    ор
    1201-950328/ 01-54682 / LGHT GREY MELANGE /S ?

    Two extra columns can be calculated into formula but for best performance it better to calculate separately.
    Attached Files Attached Files
    Last edited by BMV; 02-13-2020 at 09:54 AM.

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

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

    First, Thank you very much for your kind help; second, maybe I didn't explain well how to work with the sheet, the matter is that I need only to read the barcode of the product at "item barcode READER" and get its description at "Full Des1" based on the whole barcode sheet "BDTK_BAR", and count it as +1, if the barcode changed at "item barcode READER" the "Full Des2" will be filled according to the new barcode value.
    the form which I have made is free-to edit. it doesn't matter what columns or rows you add or delete, please feel free to edit them, the important one here is the "assortment" sheet which I have to upload it to my system. also the box number doesn't exceed 400 so any need to work on 1000 rows or more.

    The main idea here is that I need to count the products while packing them by reading their barcodes with a barcode reader tool and have the Packing List of them as the Assortment sheet shows.

    I really appreciate your help. Thanks again.

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

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

    Mark00963. actually it is very complex issue. For me it is not clear how you scan barcode and how looks like a process. I ansvered only for
    is there any chance to have the "assortment" sheet automated by formulas?

+ 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] 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