+ Reply to Thread
Results 1 to 3 of 3

Trying to track inventory using a barcode scanner in Excel

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    pa
    MS-Off Ver
    Excel 2007
    Posts
    1

    Trying to track inventory using a barcode scanner in Excel

    ok...I have a craft business with several different kinds of homemade dips and marinates. Inventory to restock has been an issue. What I am trying to do is at the craft shows I would like to scan barcodes from the back of the items so that it will automatically deduct from my inventory so I can know immediately what I need to restock with out having to manually count each bin after every show. I have set up a spreadsheet, created the barcodes with the barcode font 30f9 and now I am stuck. I need some help with the formula etc so that when I scan during a purchase it will automatically update my sheet. I know a little more than basics but this is a real challenge. Step by steps would definitely help. I have attached my spreadsheet so you can see what I did so far. ANY help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Trying to track inventory using a barcode scanner in Excel

    Hi ernht38!

    As a starting point, I would like to mention that,

    Barcode scanner are nothing except a Input device, and barcodes are nothing except a FONT..

    So, there is nothing special about it..

    Create a lookup table, and start using normally..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Trying to track inventory using a barcode scanner in Excel

    Dear ernht38,

    use below code in module.

    Please Login or Register  to view this content.
    Find attached file.

    Copy code and paste in class module.
    Attached Files Attached Files
    Last edited by satputenandkumar0; 07-01-2013 at 08:19 AM.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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