I have the perfect solution for you.
On our web site we have a sample "inventory" spreadsheet that contains
a VBA function that does a lookup in a worksheet column for data read
in from a bar code scanner and if it finds the bar code that was
scanned, it can either increment or decrement a "quantity" in the
column next to the bar code number.
You can download the Inventory.XLS file using the following URL:
http://www.taltech.com/freesoftware/Inventory.htm

For other bar code tools, tips and free software visit www.taltech.com



On Wed, 27 Apr 2005 11:21:20 -0400, "jdengel" <jdengel@firedexpgh.com>
wrote:

>Hi and thanks in advance
>
>I am using excel spreadsheet for my inventory, paint, glass cleaner ect. I manually put the number in the B & C column beside the product... now I bought a bar code scanner and I want to have the scanner put a running total in column B or C every time I scan a product. so I need excel to read from the scanner find the right product and the take that item out of stock every time I scan an item.. a column is all the bar codes for each item y column is my monthly start up numbers
>
>thanks
>John
>
>here is a example of my simple file..m column is my bal column
>
>
>
>
>
> B C D E BAL
> Bulk Bulk Qty to Unit Unit Unit to Qty in Item Cost
> IN OUT Product Description MSDS Price Qty Stock Price Qty Count Stock Total Code
> 1 Bleach ..\MSDS\BLEACH.txt $1.50 Gallon 6 $0.01 Ounce Gallon 8 $12.00 1501.1
> 12 8 Windex $3.52 Bottle 2 $0.11 Ounce Bottle =SUM(+Y170+B170-C170) $42.24 1501.1