Pedro
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See if this is faster. You'll need to change the AZ's again.
If nothing else it's 1/4 of the size of the previous workbook.
29173172a.xlsb
If nothing else it's 1/4 of the size of the previous workbook.
29173172a.xlsb
ASKER
Martin,
I filled in all the blanks to ensure I did not get an errors due to missing numbers.
Changing all the AZ's to BR's worked for me. It did all that in about three minutes time.
Impressive!