sorry if this has asked million times earlier, but i dont have a clue what kind of tags or keywords i should search.
I need a function, which removes 1 from certain row after certain value has given.
For example, C3 is input. If given value 532, then function searches from col 1 a row which has same value as input. Then it removes 1 from quantity, which is at col 2 in same row.
Im sure i can avoid negative problems and such, if i just get some directions how to start with this one.