Link to home
Start Free TrialLog in
Avatar of 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.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pedro



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.


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.