inventory
"Fernando" wrote:.
Sorry i guess i didn't explain well.
Hello ,I am trying tomake a inventory sheet.Col "A"is my starting total ,Col
"B" is my receiving total, Col "C" is my shipped total and "D "is my Total.
A B C D
5 12 7 10
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
Next day Rec 10 units 5 10 0 20
Following day Rec 15 Units ship 2 5 15 2 33
I need a total that keeps adding up.by entering a different new receiving
every day will my total will correpond to the new receiving ignoring my last
one. A" stay constant .
Hope this is more clear.
Thanks
|