Hi,

I am new to the forum, and any help is greatly appreciated. Along with being new to the forum I am a Novice when it comes to using Excel. This is what I am trying to accomplish. I already have software that allows for inventory control, but I am looking for a way to make a monthly product inventory easier. I would like to be able to scan a barcode, have excel recognize that barcode, go to that product and highlight the quantity in stock so that It can be altered. For instance, I scan barcode 4144233456 I would like excel to go to the in stock quantity. I would then count the number of items with that barcode and let say there are 5, and enter 5. I would like for 5 to be the new in stock quantity for that product with that barcode. From there I would then like to be able to just scan another barcode and then enter its quantity and so on. Thanks in advance