Hello,
I need a macro that allow me to create target sum from the grid of 7 columns and 9 rows...using technique picking a one number from each columns and making all possible targets sum can be made in the "as per specified sum target in the column S"
Example below shows only one set of sum 17 (in the columns L:R) but I hope could be made much more than ones...
Thank you all
Excel 2000
Regards,
Moti
I need a macro that allow me to create target sum from the grid of 7 columns and 9 rows...using technique picking a one number from each columns and making all possible targets sum can be made in the "as per specified sum target in the column S"
Example below shows only one set of sum 17 (in the columns L:R) but I hope could be made much more than ones...
Book1 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | |||||||||||||||||||||
2 | |||||||||||||||||||||
3 | |||||||||||||||||||||
4 | |||||||||||||||||||||
5 | n1 | n2 | n3 | n4 | n5 | n6 | n7 | n1 | n2 | n3 | n4 | n5 | n6 | n7 | Sum | ||||||
6 | -4 | 8 | 1 | 4 | -3 | 8 | 8 | -2 | 7 | 3 | -2 | 2 | 3 | 6 | 17 | ||||||
7 | 2 | -6 | 5 | -2 | 6 | -2 | -4 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
8 | 7 | 1 | 3 | 8 | 8 | -5 | 5 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
9 | 4 | -2 | 8 | 3 | 2 | -3 | -2 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
10 | 0 | 4 | 7 | 6 | -10 | 6 | 4 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
11 | 3 | 6 | -32 | 1 | -1 | -8 | 2 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
12 | 6 | 2 | 2 | -16 | 7 | 3 | 6 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
13 | 8 | 7 | -16 | 7 | 3 | 7 | -9 | ? | ? | ? | ? | ? | ? | ? | 17 | ||||||
14 | -2 | -18 | 4 | -32 | 5 | 2 | -3 | ||||||||||||||
15 | |||||||||||||||||||||
16 | |||||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
S6 | =SUM(L6:R6) |
Thank you all
Excel 2000
Regards,
Moti
Last edited: