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.