- Sep 14, 2004
- 294
- 0
- 0
Tires color interior rims lights hp radio
1 300 300 0 3000 300 300 1000
2 1200 700 300 4000 1200 700 2500
3 2400 1200 1600 4000 2400 1200 3000
4 4500 3500 3500 4000 4500 3500 4500
5 5000 12000 12000 4500 5000 12000 n/a
6 10300 12300 7800 10800 8100 8100 n/a
7 11200 12700 8100 11800 9000 8500 n/a
8 12400 13200 9400 11800 10200 9000 n/a
9 14500 15500 11300 11800 n/a n/a n/a
10 15000 n/a 19800 12300 n/a n/a n/a
Above is an example of a chart with different prices for options to design a car. I need to select one from each column. I need every possibility to build the car. The N/A's mean that there is less than 10 options.
How can I design a Macro to give me every possible permutation?
There is a little more to the question, but this is the only part I need help with.
Your help is greatly appreciated.
Thanks.
1 300 300 0 3000 300 300 1000
2 1200 700 300 4000 1200 700 2500
3 2400 1200 1600 4000 2400 1200 3000
4 4500 3500 3500 4000 4500 3500 4500
5 5000 12000 12000 4500 5000 12000 n/a
6 10300 12300 7800 10800 8100 8100 n/a
7 11200 12700 8100 11800 9000 8500 n/a
8 12400 13200 9400 11800 10200 9000 n/a
9 14500 15500 11300 11800 n/a n/a n/a
10 15000 n/a 19800 12300 n/a n/a n/a
Above is an example of a chart with different prices for options to design a car. I need to select one from each column. I need every possibility to build the car. The N/A's mean that there is less than 10 options.
How can I design a Macro to give me every possible permutation?
There is a little more to the question, but this is the only part I need help with.
Your help is greatly appreciated.
Thanks.