find the best match with sizing based on a certain sum VBA

[Sotos13]

Hello everyone,

i have this problem i have to solve. It's not that easy but here it is .... In column A i have a list of sizes maybe Hundreds Thousands.. and they might be from 10 to 100 in column B. i also have a certain target range for example 95 to 100.
i want to add all numbers in column B in order to result from 90 to 100(my target range) for example A1 with A10 = 100, A2+A3+ A11 =90, A4+A6 =90, then A5+A12 = 95 and so on.. The numbers which are used cannot be used again. The result will be a table with this info as the table below SIZE 1 and SIZE 10 100 etc or A1 and A10 something like that. I know it's hard but if anyone has an idea please be free to share

SIZE 1	90	A1+A10	100	Range 90- 100		RESULTS
SIZE 2	50	A2+A3+A11	90			SIZE 1 and SIZE 10	100
SIZE 3	30					SIZE 2 and SIZE 3 and SIZE 11	90
SIZE 4	60	A4+A6	90			SIZE 4 and SIZE 6	90
SIZE 5	70	A5+A12	95			SIZE 5 and SIZE 12	95
SIZE 6	30					SIZE 7 and SIZE 16	100
SIZE 7	80	A7+A16	100
SIZE 8	40
SIZE 9	80
SIZE 10	10
SIZE 11	10
SIZE 12	25
SIZE 13	35
SIZE 14	75
SIZE 15	95
SIZE 16	20

<tbody>
</tbody>

Thanks

<tbody>
</tbody>

 

[Sotos13]

great Dante....amazing !!!
thank you very much...i might come back to you with some questions concerning the code just so i can make some things more clear to me.
if you could reply ..but thanks again

Regards
Sotos13

 

[DanteAmor]

great Dante....amazing !!!
thank you very much...i might come back to you with some questions concerning the code just so i can make some things more clear to me.
if you could reply ..but thanks again

Regards
Sotos13

Of course, tell me what doubts you have?