Quick question about using a barcode scanner with excel

  • Thread starter Thread starter Johnsey
  • Start date Start date
J

Johnsey

I was wondering if you imported data from another program into exce
could you then use a barcode scanner to highlight the item related t
the barcode and perhaps add the date the item was scanne
 
You would use the barcode scanner to enter the barcode in the cell. Then in
an adjacent cell you could use vloopup to go against a master list of
barcodes and return related data

assume the first barcode would go in cell A2 and the imported data is on
Sheet2!A1:F200

in B2 of the barcode sheet you could put in a formula

=if(A2="","",Vlookup(A2,Sheet2!$A$1:$F$200,4,False))

when the barcode is entered in the cell, this would retrieve the data in
column D (the 4 as a 3rd argument to Vlookup) for the row in Sheet2 with the
matching barcode.
 
You must log in or register to reply here.

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

Barcode Scanner 1
Auto Detect Data, Auto Print Data, Auto Erase Data Loop 8
Barcode Scanner and macro question 1
barcode scanner 1
barcode scanner and excel 1
How do I insert barcodes from a scanner into Excel cells? 2
using a barcode scanner to validate numbers 1
Barcode and VBA 3

Back
Top