Hey guys
I have a spreadsheet with about 900 line items listed by barcode number, I want to be able to scan the barcode of the product, have the spreadsheet find the item, and then insert the quantity,
would anyone be able to let me know how to best do this?
cheers
This detailed barcode scanning user guide may help you.
As for "scan the barcode of the product, have the spreadsheet find the item"
Guess you may dynamically link each barcode number to the specific cell that containg the barcode. And then whenever you scan a barcode, then the data can be located. Or instead, try to google a barcode stock taking app...
Being on sea, sail; being on land, settle.
You can use mine spreadsheet if you still need it, it does what you need, just write it here and I will upload it, it use vlookup to find a product description
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks