inventory location flow sheet question - formula needed

[Guest]

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!

 

[Tom Ogilvy]

Formulas wouldn't be the answer in my opinion. What would tell the sheet to
move the item.

In any event, this should be done by using a database and updating the
location or otherwise keeping track using code.