Forum Discussion
Managing Inventory with Excel
Hi Sergei,
What I'm looking to do is not use more than one line. I would have my starting inventory (A1), amount used (A2), balance (A3). I want to be able to have Excel take the current balance in A3 and keep it, then subtract the new amount used and give me the new balance in A3. As an example, using 1,000 as starting balanced in A1, used parts in A2 is 200, balance in A3 is 800. Then I use an additional 100 parts, so I want to enter 100 parts in A2, and A3 would have a new balance of 700. Is there a way to do this?
Not sure, even with Visual basic programming. Assume you have 200 in A2 and balance 800. Next, you type in A2 100 on place of 200. Macro takes current balance 800 in A3, deduct 100 from it and put into A3 700. Fine.
Now assume you make a misprint, it shall be 10 in A2, not 100. You type 10 in A2, macro takes current 700 and deduct 10, balance is 690. Instead of desired 790.