Thomas
Thu Mar 27 09:37:42 CDT 2008
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.
On Sat, 15 Mar 2008 13:28:57 -0700 (PDT), vii <verbesh@gmail.com>
wrote:
>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?