Quick question about using a barcode scanner with excel
Johnsey
I was wondering if you imported data from another program into excel
could you then use a barcode scanner to highlight the item related to
the barcode and perhaps add the date the item was scanned
--
Johnsey
------------------------------------------------------------------------
Johnsey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15560
View this thread: http://www.excelforum.com/showthread.php?threadid=271229
Tom Ogilvy
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.
--
Regards,
Tom Ogilvy
"Johnsey" <Johnsey...@excelforum-nospam.com> wrote in message
news:Johnsey...@excelforum-nospam.com...
Johnsey
Thanks for that I was just wondering how would I get it to say yes or no
in that column? Also would it be possible to have the date appear in the
cell next to this to show when the item was scanned? Could you use
something like =IF G2 = yes print today's date? Or something like that
Tom Ogilvy
=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
--
Regards,
Tom Ogilvy
"Johnsey" <Johnsey...@excelforum-nospam.com> wrote in message
news:Johnsey...@excelforum-nospam.com...
>