Build packages based on remaining product

[Sleepingsouls]

Hi I'm building out a spreadsheet that will help me sell my products better - Sometimes I have leftover and/or too many of a few types so I build them into packages.
I currently have a spread sheet (see below for rough idea) that is dynamic and I can change the products I offer in different packages - at the moment the packages are manual as in, I have to say how much of each product I would like in the package, and it gives me an adjusted amount so that I don't go below 0. What I'm trying to do now is build a way for it to auto fill the packages for me based on the product I have remaining.

So if I say product A has 5 quantity and I put 2 in Package 1, 2 in package 2 and 1 in package 3 the adjusted quantity will show 0. But is there a way to tell excel if quantity of A >0 sort amount between Package 1,2,3?

Product	Weight	Qauntity	Adjusted Quantity			Package 1
A						Product	Weight	Quantity
B						A
C						B
D						C
E
F
G						Package 2
						A
						D
						F
						Package 3
						F
						G
						C
						E

 

[BSALV]

i'd suggest something like this (all in 1 line to make formulas simple)
The green cells, you can use.
C:F = the qty's are now assigning
I:K = the remaining excel is assigning, using the proportions of C:F
N:P = correction, that can be to assign the remainings in L, or the value can even be negative, if excel gave too much in the columns I:K
The yellow cells are the results

Map1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1				manually				auto					manually						total
2	Product	Weight	Quantity	package1	package2	package3	assigned 1	remaining 2	Extra1	Extra2	Extra3	assigned 2	remaining 3	Extra1	Extra2	Extra3	assigned 2	still remaining	package1	package2	package3
3	A		11	2	2	1	5	6	2	2	1	5	1				0	1	4	4	2
4	B		11		5	1	6	5	0	4	0	4	1				0	1	0	9	1
5	C		11	2	2	2	6	5	1	1	1	3	2				0	2	3	3	3
6	D		11	1			1	10	10	0	0	10	0	-9	5	4	0	0	2	5	4
7	E		11	2	3		5	6	2	3	0	5	1				0	1	4	6	0
8	F		11	2	2	1	5	6	2	2	1	5	1				0	1	4	4	2
9	G		11	2	2	1	5	6	2	2	1	5	1				0	1	4	4	2
Blad5

Cell Formulas
Range	Formula
G3:G9,L3:L9,Q3:Q9	G3	=SUM(D3:F3)
H3:H9,M3:M9	H3	=+C3-G3
I3:K9	I3	=IF($H3>0,FLOOR($H3*D3/$G3,1),0)
R3:R9	R3	=M3-SUM(N3:Q3)
S3:U9	S3	=+D3+I3+N3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R3:R10	Expression	=R3<0	text	NO
A2:U3,A4:Q9,S4:U9,R4:R10	Expression	=A2=0	text	NO
M3:M9	Expression	=M3<0	text	NO
H3:H9	Expression	=H3<0	text	NO

 

[Sleepingsouls]

I'm testing this out as we speak thank you