Variable Quantity Calculator in Excel 2007

[datagalore]

I am trying to create a variable quantity calculator in excel 2007.
I have 20 items.
Each item has a different weight ex. 1.36kg or 2.70kg etc. and a specified order quantity ex. 3 x 1.36kg, 1 x 2.70kg etc.
My total weight for all 20 items cannot exceed a set value (ex. 50kg).
If I zero the quantities in 10 of the items, I need the formula(s) to calculate the change in quantity for each of the remaining 10 items in
proportion to the weight without exceeding the set value of 50kg.

 

[Joe4]

Re-posted here: http://www.mrexcel.com/forum/excel-questions/867127-reorder-quantity-formula-please-help.html

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).