Hey Guys!
I'm trying to set up an automated inventory management system using a barcode scanner. Here is what I'm looking for:
Starting with sheet 2 ("Inventory"), I want a simple Userform that takes the input (scanned UPC) and finds that in the UPC Column. A quantity of 1 is added to the corresponding QTY Column, and then the input box is emptied. If no match is found for the scanned UPC, then I want it to highlight the UPC on sheet 1 ("Master List"), then add the UPC and a quantity of 1 to sheet 3 ("TO BE ADDED"). If it could also pull the price from sheet 1 and add that to sheet 3 as well, that would be great, but the highlighting could serve the same purpose. Does this sound do-able?
Here are some related posts:
http://www.excelforum.com/excel-gene...ode-input.html --This is the barcode scanner which adds a quantity
http://www.excelforum.com/excel-prog...-barcodes.html -- this is the Scan mode type button.
Thanks in advance!
Bookmarks