Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Barcode Scanner | Excel Discussion (Misc queries) | |||
Barcode scanner and quantities | Setting up and Configuration of Excel | |||
barcode scanner and excel | Excel Worksheet Functions | |||
Excel applications for a Barcode scanner | Excel Worksheet Functions | |||
barcode scanner | Excel Discussion (Misc queries) |