Hello,
I'm working on a file to control the products which are prepared in a parcel. In the excel file I will have one sheet with all preparation data, and second sheet will be with formulas to have only information about one specific parcel.
The way I see it, the person in charge of control will launch control form, scan the box number in the form. This number will go to B5 in "Control" sheet to retrieve data. Then the controller will take one reference, scan it, info will appear in the form, he will input quantity in the box. If quantity planned = quantity prepared, an information OK/NOK will be written.
If possible I'd like the form to detect when all products are checked to have an information on the form, which will then propose to make control of new box.
I created the form, but i'm a bit stuck from there.
If someone could help me go forward, it would be appreciated!
I'm working on a file to control the products which are prepared in a parcel. In the excel file I will have one sheet with all preparation data, and second sheet will be with formulas to have only information about one specific parcel.
The way I see it, the person in charge of control will launch control form, scan the box number in the form. This number will go to B5 in "Control" sheet to retrieve data. Then the controller will take one reference, scan it, info will appear in the form, he will input quantity in the box. If quantity planned = quantity prepared, an information OK/NOK will be written.
If possible I'd like the form to detect when all products are checked to have an information on the form, which will then propose to make control of new box.
I created the form, but i'm a bit stuck from there.
If someone could help me go forward, it would be appreciated!