I've been asked by our warehouse guy to help him with an excel spreadsheet to increase his productivity. The problem is, I'm not what you would call an "excel expert". What he wants sounds very simple, I'm just not sure how to do it.
Right now he has a USB barcode scanner. When he scans to an excel spreadsheet he would like to scan the UPC code of an item and have it automatically change to our actual part number. Can this be done? Please let me know if you would like additional information
For Example:
UPC = 38568963772
Item# = AF5155
Edit:
this show what we are trying to scan the UPC codes into.
this is a simple two column file pulled from our system.
Best Answer
In another place in the workbook (different sheet would be neatest), have a 2 column list of UPC code and part number.
Then, in the column next to where the UPC appears, use VLOOKUP:
Make sure the reference to the range is static, eg $a$3:$b$50, so if you fill the formula down the column of scanned codes the reference doesn't change.
Alternatively, if the part number needs to actually replace the UPC code, you'd need to write a macro to fire on cell changes, but this is a fair bit more work.