I am building an order form for a community produce distribution system. What happens is one person orders cases of produce for several people (users) but only full cases can be ordered. I am creating an automated sheet to simplify the ordering process. It has columns for each user (this will be placed on Google documents for use).

I have columns for case size, cases ordered and remainder in current case (among others). What I need is for it to sum the amount ordered then once it reaches the case size (113 for example) it will add 1 in the 'cases ordered' column then restart the count in the 'remainder' column. For example if there are 113 apples per case and there is an order of 125 then it will show 1 'cases ordered' and 101 'remaining' in the next open case.

I appreciate any help you can give in this matter. I have taken a VBA for excel class but I can't get in touch with my instructor for more assistance. I don't use excel enough to know the in's and out's of the functions. Thanks so much