I am trying to set up an inventory control sheet for use at a mission hospital. It is pretty basic in that each time med supply issues an item they are to track it on this spreadsheet (which keeps a running total of the stock on hand.) Each row is a different item. My problem is that to update the stock on hand column (eg D2) I need to subtract the amount dispersed (C2) from it. This causes a circular reference because I have = D2-C2 in cell D2 as I want to always update D2 to the present amount of Stock on Hand. I know how to reset C2 to zero with a macro when they open it back up but I don't know how to cleanly allow the Stock on Hand to be updated. I hope I explained this clearly. Thank you to any one who can help.
Bookmarks