Excel Inventory Spreadsheet

Hi there,

Looking for a bit of advise on how to work this out.

I work for a small fashion company and have been given the task of learning how to inventory with a bar code scanner.

I've sussed out how to get it to scan onto excel and it automatically goes onto the next line.

My problem is how can i get it to register the bar code as an actual product? and how can I get it to summarise the data instead of hundreds of the same bar codes?

So when I scan items in, it comes up like this:

8606018670000
8606018670000
8606018670017

etc.


Is there a way of getting it to say:
Code/Item/Quantity

860601867000/Blue Jacket/2
8606018670017/Yellow Jacket/1

Any help would be much appreciated

Based on your limited info, I would create a lookup table. One table would have the ItemNo and Description. The second table would come from your Excel Dump of the scanned items. Here's where you didn't mention what is in that file, but I gather that somewhere in it you can get the quantity? It would look somewhat like a Relational Database where you use one table to lookup something from the other. In excel you can use vlookup to 'relate' your scanned item with the ItemNo to give you the description.