running Total for a single cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2221225%22%20slang%3D%22en-US%22%3Erunning%20Total%20for%20a%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2221225%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20an%20inventory%20tracker%20of%20sorts.%20I%20have%20a%20106%20spaces%2C%20i%20need%20a%20sheet%20that%20displays%20the%20available%20spaces.%20so%20when%20there%20is%20106%20pallets%20there%20will%20be%200%20spaces%20available%2C%20and%20when%20there%20is%2086%20pallets%20there%20will%20be%2026%20spaces%20etc.%20im%20wanting%20to%20make%20a%20cell%20that%20displays%20%22Available%22%20and%202%20input%20cells%20which%20will%20be%20%22in%22%20and%20%22out.%22%20if%20possible%20i%20would%20like%20the%202%20input%20cells%20to%20always%20be%20empty%2C%20once%20the%20value%20is%20punched%20in%2C%20the%20Available%20Cell%20updates%20and%20the%20input%20cell%20returns%20to%20blank.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20on%20this%20would%20be%20greatly%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3ENed%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

 

I am trying to create an inventory tracker of sorts. I have a 106 spaces, i need a sheet that displays the available spaces. so when there is 106 pallets there will be 0 spaces available, and when there is 86 pallets there will be 26 spaces etc. im wanting to make a cell that displays "Available" and 2 input cells which will be "in" and "out." if possible i would like the 2 input cells to always be empty, once the value is punched in, the Available Cell updates and the input cell returns to blank. 

 

Any help on this would be greatly appreciated

 

thanks

Ned   

0 Replies