Barcode scanner inventory check with excel 2016

		Microsoft Office Forums > Microsoft Excel > Excel
Barcode scanner inventory check with excel 2016

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-20-2016, 07:10 PM

Tuph

Windows XP Barcode scanner inventory check with excel 2016

Office 2016

Advanced Beginner

Join Date: Dec 2014

Location: Melbourne, Australia

Posts: 31

Your workbook needs to included the database of products with the matching barcode number and a description.

On your working worksheet, add a helper column (say column b) next to the column you are scanning into (say, column A). In column B use a lookup formula to join the scanned barcode from column A with the description from the product worksheet.

Good luck with it.

Tags

barcode, excel 2016

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code for Grammar Check Not Working in Word 2016	PSSMargaret	Word VBA	2	06-11-2016 10:53 PM
Excel vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
How do I get a scanner to input to an excel spreasheet	BillMaintenance	Excel Programming	5	03-02-2015 05:40 AM
MICROSOFT barcode control -changing the barcode image in realtime	artner0112	Excel	1	12-18-2011 09:33 AM
I need help with keeping an inventory organized w/ WORD or Excel?	CeltFan09	Excel	2	05-04-2011 05:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 AM.