How do you do....it? Thread, Need scanner in excel for product verification in Technical; Hello,
I need a way to have a spreadsheet containing UPC and corresponding item#, so that when a person is ...
17th January 2013, 06:43 PM #1
- Rep Power
Need scanner in excel for product verification
I need a way to have a spreadsheet containing UPC and corresponding item#, so that when a person is checking a pulled order they can take an item out of the box , scan it and it pull up the correct item number. I know I can do this with the find feature, but too much for a non computer user to figure out. I know there is way to do it in excel, when I created the spread sheet and scanned an item it just added the barcode in the sheet. Any help would be appreciated.
17th January 2013, 10:27 PM #2
Scanners these days tend to operate as USB keyboards - scan a barcode and they "type" the scanned code into the computer as if someone just typed on a keyboard. There, you don't need to write anything special to interface with the USB scanner, you can treat it exactly the same as if someone is going to type the barcode in - a macro with a single text input field for the barcode that searches for the code in your spreadsheet should do it.
Originally Posted by cgibbons2
By schugh in forum Coding
Last Post: 20th April 2012, 09:45 AM
By ctaylor in forum MIS Systems
Last Post: 14th September 2011, 10:05 PM
By albertwt in forum Windows Server 2000/2003
Last Post: 10th March 2010, 11:56 AM
By projector1 in forum How do you do....it?
Last Post: 14th February 2007, 01:41 PM
By tosca925 in forum Scripts
Last Post: 12th September 2005, 10:47 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)