Quick question about using a barcode scanner with excel

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

Johnsey

Thanks for that I was just wondering how would I get it to say yes or n
in that column? Also would it be possible to have the date appear in th
cell next to this to show when the item was scanned? Could you us
something like =IF G2 = yes print today's date? Or something like tha
 
If the scanned barcode appears in F2 as an example:

=if(F2="","",if(iserror(match(F2,Sheet2!$A$1:$A$100,0))"No","Yes"))

where the list of barcodes to be checked against is in Sheet1 in cells
A1:A100.

any date produced by a formula would change/update whenever the sheet was
recalculated unless you wanted to introduce intentional circular references.
Easier might be to use the change event to populate an adjacent cell with a
hard coded date

See Chip Pearson's page on events:

http://www.cpearson.com/excel/events.htm
 
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

Quick question about using a barcode scanner with excel 1
Auto Detect Data, Auto Print Data, Auto Erase Data Loop 8
Barcode Scanner and macro question 1
barcode scanner 1
using a barcode scanner to validate numbers 1
Speek cells, barcode scanner 3
Excel A CountIF question... I think 2
Barcode and VBA 3

Back
Top