zbor thanks you very for reply and solution provided by you I would like to tell you that data (Fruit Data Base) once that any fruit quantity is used/ended, code show error that "All available quantity of Apple is used.

Below is error in yellow highlighted result after running macro.Total Available qty of apple is 13 but distribution is 20 shown macro result.

test.jpg