Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-503455%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503455%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20writing%20a%20Excel%20spread%20sheet%20for%20stock%20visibility.%20It%20has%20ten%20columns%20and%20102%20lines.%3C%2FP%3E%3CP%3Ecolumn%20A%20is%20the%20name%20of%20the%20product%2C%20B%20is%20how%20many%20in%20the%20warehouse%2C%20C%20is%20how%20many%20available%20of%20the%20product%2C%20D%20is%20committed%20stock%2C%20E%20delivered%20stock%2C%20J%20received%20stock.%20The%20others%20columns%20have%20no%20bearing%20on%20the%20sheet%20or%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20formulas%20are%2C%3C%2FP%3E%3CP%3EB%3D%20J2-%20E2%2C%3C%2FP%3E%3CP%3EC%20%3D%20B2%20-%20D2%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20manually%20put%20in%201%20in%20column%20D%20(committed%20stock)%20which%20then%20reduces%20Column%20C%20(available)%20by%201%2F%20or%20the%20amount%20you%20first%20entered.%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'm%20trying%20to%20do%20is%20when%20I%20then%20deliver%20the%20goods%2C%20I%20manually%20increase%20the%20number%20in%20column%20E%20(%20Delivered)%20I%20want%20the%20number%20in%20column%20D(committed)%20to%20reduce%20by%20the%20same%20amount%20automatically.%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20needs%20to%20be%20done%20with%20out%20effecting%20the%20rest%20of%20the%20spread%20sheet%20and%20I%20still%20need%20to%20be%20able%20to%20manually%20change%20column%20D%20with%20out%20changing%20anything%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20some%20one%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-503697%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503697%22%20slang%3D%22en-US%22%3EFor%20clarity%2C%20please%20attach%20your%20sample%20file%20with%20the%20manually%20entered%20results%20you%20want%20to%20be%20returned%20by%20a%20formula.%3C%2FLINGO-BODY%3E
Thedonk6919
Occasional Visitor

I am writing a Excel spread sheet for stock visibility. It has ten columns and 102 lines.

column A is the name of the product, B is how many in the warehouse, C is how many available of the product, D is committed stock, E delivered stock, J received stock. The others columns have no bearing on the sheet or formulas.

 

the formulas are,

B= J2- E2,

C = B2 - D2 

So I manually put in 1 in column D (committed stock) which then reduces Column C (available) by 1/ or the amount you first entered. 

What I'm trying to do is when I then deliver the goods, I manually increase the number in column E ( Delivered) I want the number in column D(committed) to reduce by the same amount automatically. 

this needs to be done with out effecting the rest of the spread sheet and I still need to be able to manually change column D with out changing anything else.

 

Can some one help?

 

1 Reply
For clarity, please attach your sample file with the manually entered results you want to be returned by a formula.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies