Thread: inventory
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 268
Default inventory

You are so very right and correct Sir! Serious oversight on my part, thanks
for the correction! And obviously, Col A can also use a formula. Say in A3,
enter the formula =D2, to bring down the total for the previous day.

"JLGWhiz" wrote:

The formula goes in col D. You can enter it in the first cell in column D
and then drag it down the entire column by clicking on the first cell and
holding while you drag.

"Fernando" wrote:

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 5 5 5
My receiving total change all the time ,netxt day might be ,received 10
units,no shipping
5 15 0 20 I need a total that keeps adding up.