How to create a simple barcode inventory for in and out office supplies

[jpena374]

Hi,

I am looking to do a simple barcoding excel sheet that will be used for some office supplies.

All I need is to scan a barcode and have it deducted from an available quantity.

If possible I would like the quantity cells to go both ways, an option where I can add or remove by scanning a barcode.

Scenario: I go into our inventory room, pull a product, I want to scan it and see that it deducted the quantity list for that particular product.

When new items arrive, I also want to be able to scan them back into inventory.

Just an in and out scanner inventory for excel. (screenshot attached)

All and any support is greatly appreciated! Thank you!