Hey all,
I am pretty new here. I looked at a few of the threads related to inventory but none would do what I want to do. Basically, I want to scan a box that will have shirts in it. The box will have a barcode with the item number on it and then a barcode with the quantity. I was hoping to figure it out so that when the item number was scanned, excel would jump to that item column and the the quantity in the box would be added underneath to keep a running total.
We are trying to inventory a warehouse with many boxes of shirts (typically 80-120 shirts per box) We need to run inventory about once a week and we need a pretty automated system to scan the entire warehouse. Any ideas where to start? I figured out vlookup and sumif but they didn't seem to want to work together. I just want to simplify everything so I don't have to do any sorting and organizing after i scan the entire warehouse.
Thanks for any and all help!
I am pretty new here. I looked at a few of the threads related to inventory but none would do what I want to do. Basically, I want to scan a box that will have shirts in it. The box will have a barcode with the item number on it and then a barcode with the quantity. I was hoping to figure it out so that when the item number was scanned, excel would jump to that item column and the the quantity in the box would be added underneath to keep a running total.
We are trying to inventory a warehouse with many boxes of shirts (typically 80-120 shirts per box) We need to run inventory about once a week and we need a pretty automated system to scan the entire warehouse. Any ideas where to start? I figured out vlookup and sumif but they didn't seem to want to work together. I just want to simplify everything so I don't have to do any sorting and organizing after i scan the entire warehouse.
Thanks for any and all help!