Hi Everybody,
The Macro will Generate ALL Possible 4 Number Combinations Along with the TWO Chosen DN ( Designated Number ) Numbers at the Beginning of EACH Combination.
"You ONLY Need to Input Two Criteria :-
( 1 ) The ACTUAL Numbers to be Used ( Starting in Cell A1 and Continuing Down ).
( 2 ) The TWO DN Numbers to be Used ( In Cells L3 AND L4 ).
You then Press the Calculate Combinations Button.
The Combinations will be Listed One Combination Per Cell in the Format DN1-DN2-N1-N2-N3-N4, with EACH Number being Separated by a Dash ( ""-"" ). The Combinations will Start in Cell A1 of the Sheet Named Combinations and Continue Down. When the Combinations Being Listed Reaches 65,500, the Macro will Automatically Shift 1 Column to the Right, and Continue Down from that Columns First Cell, and so on Until ALL Combinations have Been Listed."
You can Run the Macro Using ANY TWO DN Numbers & ACTUAL Numbers to be Used ( Upto and Including a MAXIMUM of 143 Total Numbers to be Drawn from, these Numbers can be ANY Numbers, i.e. 1, 15, 38, 45, 58, 70, 83, 99, 109 etc ) by Changing the Criteria in the Sheet Named Customized Generator.
PLEASE NOTE :- The TWO DN Numbers MUST be Different from ANY of your ACTUAL Numbers.
Here is the Direct Link :-
http://www.mytempdir.com/448137
You will Need to Enter the Password :-
CombinationsPlusTWODNPAB
I have Checked Out the Link and Password and Everything Seems to be OK.
Have Fun Everybody!.
All the Best.
PAB
The Macro will Generate ALL Possible 4 Number Combinations Along with the TWO Chosen DN ( Designated Number ) Numbers at the Beginning of EACH Combination.
"You ONLY Need to Input Two Criteria :-
( 1 ) The ACTUAL Numbers to be Used ( Starting in Cell A1 and Continuing Down ).
( 2 ) The TWO DN Numbers to be Used ( In Cells L3 AND L4 ).
You then Press the Calculate Combinations Button.
The Combinations will be Listed One Combination Per Cell in the Format DN1-DN2-N1-N2-N3-N4, with EACH Number being Separated by a Dash ( ""-"" ). The Combinations will Start in Cell A1 of the Sheet Named Combinations and Continue Down. When the Combinations Being Listed Reaches 65,500, the Macro will Automatically Shift 1 Column to the Right, and Continue Down from that Columns First Cell, and so on Until ALL Combinations have Been Listed."
You can Run the Macro Using ANY TWO DN Numbers & ACTUAL Numbers to be Used ( Upto and Including a MAXIMUM of 143 Total Numbers to be Drawn from, these Numbers can be ANY Numbers, i.e. 1, 15, 38, 45, 58, 70, 83, 99, 109 etc ) by Changing the Criteria in the Sheet Named Customized Generator.
PLEASE NOTE :- The TWO DN Numbers MUST be Different from ANY of your ACTUAL Numbers.
Here is the Direct Link :-
http://www.mytempdir.com/448137
You will Need to Enter the Password :-
CombinationsPlusTWODNPAB
I have Checked Out the Link and Password and Everything Seems to be OK.
Have Fun Everybody!.
All the Best.
PAB