Scanning Barcode, match with excel, VBA

P

prasan ayyan

I got a barcode scanner attached to a laptop. I my excel sheet, column A has source#, column B has item to keep or discard. I have a barcode label (source#) on the item in the shelf, so when I scan the barcode label, I want excel to take me to the source# match in the column A. so I will get to see column B to keep the item or to discard. And I also wanted the row to turn green for keep and red to discard. Can anybody PLEASE help with creating VBA using Macro?
Column A Column B
Source# Keep/discard

1572156 Keep
1572293 Discard
1572299 Keep
1572211 Discard
1572364 Keep
1572386 Discard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
Mail Merge Help 1
Autonumber field in Excel that behaves the same as Access 0
Embedded Excel into Word with Tables 0
Need simple VBA to change cell value or display a message 1
Consolidation Table from Different Excel Tabs with Different Format 1
Automation of scanned file storage based on content 0
Excel Gurus!! Need a macro to find and assign 3

Top