so .. whenever a value is added to "Faulty" (column J) you want it immediately added to the "Faulty Warehouse" stock (Column H) (column J) and the "Faulty" set to 0
You will have to use VBA ("Worksheet Event") to initiate the required action AND you need to ADD the "faulty" to the existing "Faulty Warehouse" stock which cannot be done with a formula in "Warehouse Stock".
To do the VBA we need an exact copy of your real workbook if it is different to last post: are the respective columns H and J?
See attached: add value in J and H is updated.
Bookmarks