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

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!

Hello jpena374,

Welcome to the Forum!

The forum seems to be experiencing some issues with posting. You screen shot did not attach.

Attaching your workbook is the best option for getting help with your problem. Please remove or change any sensitive or confidential information before you post. If you still have trouble posting then try using a public file share site like DropBox, Mediafire, 4Shared, etc. Remember to include the URL in your post.