+ Reply to Thread
Results 1 to 2 of 2

Inventory, Barcode scanning

  1. #1
    Registered User
    Join Date
    12-13-2018
    Location
    Louisville
    MS-Off Ver
    2016
    Posts
    1

    Lightbulb Inventory, Barcode scanning

    I am novice to Excel. I am trying to create a simple spreadsheet for inventory scanning. In my department there will be total of 6 items scanned.
    What I need is this:
    A1 = user scans his/hers ID badge (this is a 6 digit barcode number from their ID tag)
    B1 = user scans customer ID (this is a 9 - 12 digit barcode number)
    C1 = use scans the items issued (this is 5 characters unique to item barcode tag, no 2 items barcodes are alike)
    Upon item return, user (any user) would have to scan the item barcode (this would match the item on spreadsheet, mark it as returned), then user would scan their ID badge and this info would go with the item return for auditing purposes. Then the row matching the item issued/returned would become hidden, be moved to separate sheet, or something to keep spreadsheet very nice and clean. Like I said, we would need to be able to pull up the audit of which user issued the item, which user returned it.
    Having a date of issue and date of return would be "nice to have" bot not must have.
    Thanks all for reading this and for attempting to help. I truly appreciate it.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Inventory, Barcode scanning

    Hello csntt30 and Welcome to Excel Forum.
    This proposal doesn't hide rows, rather it will display the rows of items issued and returned on the 'Returned' tab and items issued but not returned on the 'Issued' tab.
    The 'Raw' tab is where all activities are recorded.
    Column E is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Column F is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The 'Issued' tab is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The 'Returned' tab is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If this won't work for your situation, please upload a desensitized sample of your raw data along with a manually produced mock up of your desired output by clicking on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 0
    Last Post: 03-17-2017, 10:52 AM
  2. barcode scanning
    By mojobaabby in forum Excel General
    Replies: 12
    Last Post: 02-01-2017, 04:19 PM
  3. Barcode scanning help
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2016, 04:36 AM
  4. Barcode scanning
    By abirup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2016, 08:39 AM
  5. VBA barcode scanning
    By JoboM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2015, 02:30 AM
  6. Barcode Scanning - Library
    By _LG_ in forum Excel General
    Replies: 1
    Last Post: 12-05-2011, 11:55 AM
  7. Barcode scanning inventory management with running totals
    By PGOIBOY in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2011, 04:19 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