So heres the goal:
I am trying to design a spreadsheet for our store room inventory.
I work in an IT department, so we have hundreds of various parts and pieces that we store, from printers to boxes of cable to small ethernet jacks.
My thought is to make a barcode for each type of item (I can't just scan the barcode because some things are the same product with a different manufacture) and then scan in the quantities for each.
Once I have my inventory count i was going to make three barcodes, one for adding, subtracting, and loaning, and set them to remove or add stock as i scan.
Then to keep the inventory numbers correct you would simply scan the item, then scan corresponding barcode for what you are doing with the product.
Is this possible? If so what do i need to do to create barcodes in excel tied to each product, create stock removal/addition barcodes, and program the spreadsheet to do what i need.
Bookmarks