Good morning everyone,
I would like to do a macro that does permutations by a selected number producing "unique, random" combinations only pertaining to the inputted number in a cell in my workbook. I would like to control how may combinations the macro would also produce, telling the macro to give me only 200 combinations or so.
I would input the number (9) I to a cell in my workbook thus the macro would only produce "unique,random" combinations pertaining to the inputted number.
Examples.
9-15-23-36-42-53
9-21-36-48-50-51
9-12-25-34-44-49
I have a sample workbook.
Thank you,
I would like to do a macro that does permutations by a selected number producing "unique, random" combinations only pertaining to the inputted number in a cell in my workbook. I would like to control how may combinations the macro would also produce, telling the macro to give me only 200 combinations or so.
I would input the number (9) I to a cell in my workbook thus the macro would only produce "unique,random" combinations pertaining to the inputted number.
Examples.
9-15-23-36-42-53
9-21-36-48-50-51
9-12-25-34-44-49
I have a sample workbook.
Thank you,