Create Maximum combinations in renamed sheets for specific groups only
The attached file contains code that makes combinations from data in "sheet1" B10:AG19 and puts them in sheets "Numbers_X" where "X" is the first number in B10:B19.
When the code is executed again it deletes data in sheets "NumbersX" then writes new data.
The goal here is to edit the code to maximize the number of combinations made.. The current script makes combinations using 32 numbers from "sheet1" (grey / white alternate for easier view). The current code also uses the first number as the only common number as can be seen in sheets "Numbers_X".
The additional numbers have been highlighted light and dark yellow. If it is not possible to max at 69-70 then I'll accept the maximum possible under the circumstances. Please specify the maximum possible numbers used so I can adjust the data accordingly. CreateMaxCombinationsForSpecificGro.xlsm
Microsoft ApplicationsVBAMicrosoft ExcelMicrosoft Office