I have an inventory excel file. In cell F2, I have a button that I would like to perform the following action when clicked: For the fields labeled QUANTITY and ORDER, subtract ORDER[cell] from QUANTITY[cell] and return result in QUANTITY[cell]. After which, script should clear/reset all values from ORDER field. This is essentially taking a customer's quantity requests, subtracting it from the total inventory on hand so that the new quantity totals are properly reflected when the order is executed. There should be a command prompt informing the user "Are you sure you want to execute the pick list?", and the QUANTITY fields should be locked and only editable by executing the script.
Updated Warehouse file attached. We had to edit a little bit of the layout and design of the template. No structural changes.
16 freelanceria on tarjonnut keskimäärin 34 $ tähän työhön
I am an experienced programmer, with more than 10 years of experience. I understand exactly what you need. I promise you will be satisfied with my work. Thank you for your trust.