Quick question about using a barcode scanner with excel
 

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

--
Johnse
-----------------------------------------------------------------------
Johnsey's Profile: http://www.excelforum.com/member.php...fo&userid=1556
View this thread: http://www.excelforum.com/showthread.php?threadid=27122

Quick question about using a barcode scanner with excel
 

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.

--
Regards,
Tom Ogilvy

"Johnsey" wrote in message
...

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...o&userid=15560
View this thread: http://www.excelforum.com/showthread...hreadid=271229