Hi there!
I am trying to create an all-in-one excel spreadsheet for my inventory control. I have gotten as far as creating a master stock list including a code, description, cost, and quantity booked into the system originally.
I am now working on a second sheet on which to keep a running total of all good incoming and outgoing using a vlookup to pull the information based on a code. The last thing I need to get down pat if a way to alter the running total "On Hand" column to not just take the value of stock originally booked and subtract the amount booked out each time. It is difficult for me to explain, but I am hoping someone can take a look at the attached file and offer some tips/a solution?
Thanks in advance!
Inventory Control Example.xls
Bookmarks