Results 1 to 6 of 6

how to make a inventory list using barcode scanner

This is a discussion on how to make a inventory list using barcode scanner within the Excel Questions forums, part of the Question Forums category; Hi, i am brand new to this forum, and not so fluent in excel for more complicated tasks. i have ...

  1. #1
    New Member
    Join Date
    Jan 2012
    Posts
    2

    Default how to make a inventory list using barcode scanner

    Hi, i am brand new to this forum, and not so fluent in excel for more complicated tasks.

    i have been looking for a solution for this online, but seem to be running in circles, so thought i would post here.

    I want to make an shipping list using a barcode scanner. i have a master list that contains all of the inventory numbers and the relevant item data in each row. i would like to be able to scan the barcode of the item and have excel automatically look up the row from the master list and put it into the shipping list.

    I would appreciate it if someone could point me in the right direction for this. thanks in advance for any help!

  2. #2
    Board Regular
    Join Date
    Apr 2011
    Posts
    180

    Default Re: how to make a inventory list using barcode scanner

    You will have to do this by first getting a bar code font for excel and a USB scanner so that you can attach it to your computer.

    You can enter bar code fonts in Google search and download one for the type of bar code you are scanning. This will give you the ability to scan and have the cells populate with the bar code number that your scanning.

    The next step with be to do a look up function (vlookup, or index,and match) with the scanned number against your master file to populate your form with the item description as you scan.

    Hope this helps

  3. #3
    Board Regular
    Join Date
    Jan 2011
    Posts
    104

    Default Re: how to make a inventory list using barcode scanner

    Quote Originally Posted by lenaraiwa View Post
    Hi, i am brand new to this forum, and not so fluent in excel for more complicated tasks.

    i have been looking for a solution for this online, but seem to be running in circles, so thought i would post here.

    I want to make an shipping list using a barcode scanner. i have a master list that contains all of the inventory numbers and the relevant item data in each row. i would like to be able to scan the barcode of the item and have excel automatically look up the row from the master list and put it into the shipping list.

    I would appreciate it if someone could point me in the right direction for this. thanks in advance for any help!
    Download a font calle 'free 3 of 9'. It is a standard barcode font - you can create barcodes by putting a * before and after whatever the barcode you want i.e *brochure01* in font free 3 of 9 would return the value brochure01 when scanned - it is a MUST to have the * at either side. Also as mentioned above, once you have scanned this - use the value returned with a vlookup formula against your master inventory list to return the other values.

    I have recently created something very very similar so would be able to help you further if required, could also send examples of my code.

    Cheers
    Graham
    Last edited by gbell3587; Jan 21st, 2012 at 05:12 AM.

  4. #4
    New Member
    Join Date
    Jan 2012
    Posts
    2

    Default Re: how to make a inventory list using barcode scanner

    thanks for the responses. I had downloaded the code 128 font and have been using it prevoiusly. was fooling around with the Vlookup formula before posting so will continue to tinker with that. thanks again!

  5. #5
    New Member
    Join Date
    Mar 2013
    Posts
    5

    Default Re: how to make a inventory list using barcode scanner

    Quote Originally Posted by lenaraiwa View Post
    thanks for the responses. I had downloaded the code 128 font and have been using it prevoiusly. was fooling around with the Vlookup formula before posting so will continue to tinker with that. thanks again!
    Sorry, do you mean you have found a free way to make an inventory list using barcode scanner?

  6. #6
    Board Regular
    Join Date
    Apr 2011
    Posts
    180

    Default Re: how to make a inventory list using barcode scanner

    Quote Originally Posted by brodyhunt View Post
    Sorry, do you mean you have found a free way to make an inventory list using barcode scanner?

    Here is a site with a link to down load the font for free []Free Barcode Font - Code 128

    Follow instructions, after you install the font, hook up a USB scanner and you can scan barcodes in excel

    There are other sites also, just do a google each for them

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com