#inventory

Hi, I'm trying to create an inventory sheet on excel. How I'm able to scan in a barcode on cell B3 and move all the data down one row only for column B, not the entire row. I would like this to work for each separate columns so if I scan a barcode on cell C3, all the data just on column C...

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

Hello guys! I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it (the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first...

Hello Experts, I need your help to automate a long manual activity which takes allot of time. Every week I have received stock transfer requests of 500 line items from LHR and ISB to replenish the stock from KHI which is our central Warehouse to feed both locations. Please see below table with...

Hello! I'm a self-taught Excel novice trying to create an inventory system, and would greatly appreciate any help from The Masters :) I'm using Excel 2007 to create the system for an Auto Shop, which stores many multiples of the same part/s but quickly depletes stock. Basically, I'd like...

Hello, I am usually pretty good with formulas, but today I cannot get this to work. I want to keep track of issued printed goods to a customer. I have the total in cell G3 which is 1000 In cell G4 i want to keep track of the balance. in the cells below will be the issued stock on a weekly...