Scanning and Finding Barcodes

[vii]

I am trying to develop a tool for taking inventory. I have a
spreadsheet with three columns - QTY, ITEM#, DESC. The sheet lists
the items#'s of every item and their description. The QTY column is
blank. When I scan a barcode, I want it to find the item# and then
automatically put my cursor into the QTY cell next to the found item#
so I can manually punch in how many I count.

I think this should be easy, I just don't even know the first thing
about programming this sort of thing. Can someone help me?

 

[DM]

http://www.google.com/search?hl=en&q=microsoft+excel+barcodes

 

[Thomas Lutz]

There is a sample Excel "inventory" example spreadsheet that you can
download from the following web page:

http://www.taltech.com/freesoftware/Inventory.htm

The file that you download is an Excel workbook that contains a
special VBA coded "lookup" function that will search down column A in
the workbook looking for a number that you can enter either with a bar
code scanner or on the keyboard and if it finds a match, it will
highlight the row containing the matching number. You should be able
to easily modify the VBA code to do exactly what you want to do.