Jan 18 2020 11:45 AM
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
Jan 19 2020 12:16 AM
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.