I want to keep a running total of inventory as follows:
On Hand This Shipment Quan Updated
Part # 1 10 5 update this column on
each new shipment
Part # 2 15 10
Part # 3 20 30
I will not be adding lines, just updating the "this shipment" cell for each
part#
I am using Excel 2007 Please help !
JE McGimpsey - 11 Apr 2008 19:00 GMT
See
http://www.mcgimpsey.com/excel/accumulator.html
> I want to keep a running total of inventory as follows:
> On Hand This Shipment Quan Updated
[quoted text clipped - 7 lines]
>
> I am using Excel 2007 Please help !