Hello to all my problem is i have created a database of stock the formula i have used is =stock level +added stock - picking ending up with a figure in total stock my problem is i want the total stock to deplete each time i pick and only increase when i add but my formula does not do that once i change the picking stock the total stock changes please could anyone help me to solve this one !!!!!
My only thought is that i am creating this in one work book perhaps i need it to be in another workbook i await any help
Regards
My only thought is that i am creating this in one work book perhaps i need it to be in another workbook i await any help
Regards