Thread: inventory
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fernando Fernando is offline
external usenet poster
 
Posts: 21
Default 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