inventory location flow sheet question - formula needed

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!

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.

--
Regards,
Tom Ogilvy

"desertristra" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>