Generate all possible combinations from 4 sets.

Using Excel 2010
Hello,

I am sure this is bit tricky question.

1st option I want to make all possible combinations from the 4 data sets, are in the column C, D, E and F…Result in the column I:L

2nd option I want to generate only those combinations they pass min & max sums as per value given in the cells I1 & I2.

Note: Why I want 2nd option in this example there are only 26880 sets…but (for example if data increase in 4 columns say for in C=55, D=70, E=35, F=30…so this will be 55*70*35*30 = 4042500 combinations…so far restring min and max would be handy.

I have tried to as much as possible clearer in the workbook I need count in the row D4:AO4 but if any question I will try to answer.

Please help.

Regards,
Moti