Cell absorb value that user input

%3CLINGO-SUB%20id%3D%22lingo-sub-1116512%22%20slang%3D%22en-US%22%3ECell%20absorb%20value%20that%20user%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116512%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20EVERYONE%2C%20i%20am%20working%20on%20a%20little%20%22inventory%20project%22%20and%20i%20have%20a%20question.%3CBR%20%2F%3EIs%20it%20possible%20to%20make%20a%20cell%20that%20will%20absorb%20the%20value%20that%20user%20input%2C%20so%20that%20the%20next%20user%20do%20not%20have%20to%20summon%20by%20previous%20number.%20(you%20will%20see%20on%20the%20picture)%3C%2FP%3E%3CP%3EExample%3A%20Element%20C-10%20is%20already%2028%20pieces%20out.%20Now%20if%20i%20take%205%20more%2C%20i%20have%20to%20sum%2Fadd%20up%2028%2B5%3D33%2C%20and%20putt%2033%20in%20CELL-G5.%3C%2FP%3E%3CP%3EI%20want%20to%20make%20that%20when%20user%20input%20the%20number%20in%20one%20of%20the%20G-cells.%20It%20automatically%20substract%20and%20make%20the%20cell%20empty%20again.%3C%2FP%3E%3CP%3EWhat%20will%20be%20the%20easyest%20way%20to%20do%20that%3F%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20time!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20Regards%2C%20Gasper%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1116512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116822%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20absorb%20value%20that%20user%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116822%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523813%22%20target%3D%22_blank%22%3E%40Brci11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20build%20a%20solutions%20for%20this%20issue.%20Please%20take%20a%20look%20at%20attached%20file.%20Just%20enter%20some%20values%20in%20column%20B%20and%20then%20press%20the%20picture%20to%20start%20the%20macro.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello EVERYONE, i am working on a little "inventory project" and i have a question.
Is it possible to make a cell that will absorb the value that user input, so that the next user do not have to summon by previous number. (you will see on the picture)

Example: Element C-10 is already 28 pieces out. Now if i take 5 more, i have to sum/add up 28+5=33, and putt 33 in CELL-G5.

I want to make that when user input the number in one of the G-cells. It automatically substract and make the cell empty again.

What will be the easyest way to do that?

Thank you very much for your time!

Best Regards, Gasper

1 Reply
Highlighted

Hi @Brci11 

 

I tried to build a solutions for this issue. Please take a look at attached file. Just enter some values in column B and then press the picture to start the macro.