Hi, I have an inventory list that I want to update the "On-Hand" field, keep
the running total, from an update entry into the "this shipment" field for
each inventory item. I will not be adding lines, just updating the "this
shipment" cell for each product. I want it to look like this:

On Hand This Shipment Running Total
Product #1 5 3 8
Product #2 10 -5 5
Product #3 20 10 30

Then, when my next shipment comes in i want to key in the "this shipment"
and the Running Total field updates. All I can think of is a "circular
formula" and that doesn't work.
Thanks !!!