Random Number Generator with Conditions
Posted on 2011-10-18
I'm creating a demonstration macro of a model where I need to generate two columns of numbers randomly but with certain conditions. Each column contains 15 cells (15 rows), that need to be populated when the subroutine is run. The numbers in the first column must fall between 1 and 10 and always be less then the numbers in the second column. So in Column 1 you may have a randomly generated 6 which means in Column 2 the number would have to be 6, 7, 8, 9 or 10.
Thank you in advance,