Bar Code Problem excel

[jdengel]

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

 

[Thomas Lutz]

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