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!

inventory location flow sheet question - formula needed
 

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" wrote in message
...
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!