How do I get the columns in my inventory location sheet to automatically
subtract from one location (column A) and automatically add to the other
location (column B). I have three locations that flow in sequence - items
are fiirst delivered to location A, some are then moved to location B, and
ultimately all end up at location C before being sold. What is the formula I
would need to input to correctly have the inventory flow from A to B to C?
(I'm a new user and couldn't find an answer in the archives or help). Thanks!