inventory spreadsheet

[Barry]

I want to create an inventory spreadsheet using Excel.

Some background: I want to scan inventory bar codes using a "Symbol" brand scanner. When scanning with the Symbol scanner I already possess, it will populate a cell within Excel with the correct number corresponding to the bar code.

What I hope to accomplish: When I eventually fill the Excel spreadsheet with the scanned inventory numbers (for example in column A) -- on all future scans -- I want to be able to populate (in column B) a +1 for each time a particular bar code is scanned. In other words, as I scan multiple items of the same number, each time I scan them, the total is increased by one in column B

And if possible when scanning -- for Excel to find the the already inserted inventory number -- and to increase the total by one in column B for each scan.

Is there already an Excel spreadsheet out there that would accomplish this?

Thanks for any help...Barry

 

[buxtongt]

I think your biggest issue is going to be getting that scanner to communicate to excel directly. Without that any sheet you have is pointless. Is there a direct connection between the scanner and the pc? Do you know what format the data is coming in as?

 

[ff_emt1]

Getting the scanner to communicate with Excel is no problem. I am using a Symbol bar-code scanner to read job numbers that are bar-coded on the job ticket. It will enter the job number in a cell, and I have the bar-code scanner programmed to input an "Enter" or "carriage return" in after it reads the bar code so it skips to the next cell automatically. Most scanners, at least the 1D kind (bar-code is just lines up and down) are glorified automatic keyboards. Scan the code, convert to text/numbers/characters, input the text/numbers/characters somewhere. As far as I know, 2D (think the bar code on your UPS package that is read side to side AND up and down) are the same.

Can not help you with the calculation unless you can somehow use the COUNT or COUNTIF functions.
Scan into column A.
Then in column B maybe something like =COUNTIF(A1:A6,"=A6")
I don't know how to make it look at A6 so that it knows what to look for.

Maybe someone else can help.