Hi there, i dont have much experience with excel, and i need certain macro that will do the following :
If value in one cell increases, i want excel to auto-decrease value in several other cells !
For example, i have cell "chair", when i make chair i put number 1 in that cell (i made 1 chair) now i want excel to decrease amount in cells that are used as parts
( - 4 woden legs in cell B5, - 8 screwes, - 200ml of paint, etc ).
i want to track material i have, so i am never in situation i become out of some material i need.
If value in one cell increases, i want excel to auto-decrease value in several other cells !
For example, i have cell "chair", when i make chair i put number 1 in that cell (i made 1 chair) now i want excel to decrease amount in cells that are used as parts
( - 4 woden legs in cell B5, - 8 screwes, - 200ml of paint, etc ).
i want to track material i have, so i am never in situation i become out of some material i need.