Programming Questions? Ask a Programmer for Answers ASAP
let me see if I can get this strait, you want to select random 3 digit numbers, but break it into 3 columns instead of 1, but you want to be able to specify which numbers can go in which columns, and the number of rows. So if for example you said 25, you would get 25 rows, 1000 you would get a 1000 rows, with some obviously repeating numbers.
i see you have a fancy form. are you trying to do something like that?
I was thinking something much simpler
sorry sent the wrong image
the idea being, that you would enter the numbers you wanted in sheet 1, and in sheet 2 the results would be output
so do you just want to know the maximum number of combos or the maximum number or just tell it how many rows.
The maximum is easy to calculate
if you have 5 numbers in the first column, 3 in the second, 2 in the 3rd, its just 5*3*2, or 30 maximum possible.
the output would just be simply something like
1 3 5
2 4 4
0 5 3
8 1 2
7 2 7
6 6 6
and so on, for whatever numbers you chose.
If you just want to skip definding the number of rows and just have the maximum number of combos put out in random order, that is simple enough to do
ok, i am sending you the additional service offer now, for the cost of creating this macro.
when you accept it I can get started.
do you still want to go through with this?
ok, this is fine, stuff happens.
Yes you are correct, if you look at my 2nd picture I posted, you will see that you can repeat numbers as many times as you like.
and in cell D2 you put the number of rows.
Keep in mind if you say 25 rows for example, and only 20 combintations are possible only 20 rows would be output.
I sent you an additional service offer a while back. You would have to accept that offer before I could get started on any of the programming for this.
sent another additional service offer, incase the other one sent a while a go was lost