Hi Everyone,

I will try and explain simply what I would like to achieve.
I have a Macro that produces combinations ( it produces them in memory
and then inserts them into the Active Sheet ). I ONLY want
Combinations ( with 6 Letters in each combination ) that appear in ANY
Two Groups as Per the Grid ( the Grid Structure could possibly change
) below :-

Example Grid :-
Group 1 - A,F,K,O,S,W
Group 2 - B,G,L,P,T,X
Group 3 - C,H,M,Q,U,Y
Group 4 - D,I,N,R,V,Z
Group 5 - E,J

So A,K,W,P,M,Q and K,S,B,X,D,I would be EXCLUDED. In addition I would
also like to be able to, instead of having ALL Six Letters in ONLY ANY
Two Groups, maybe have the Option to put the Scenario - 4 Letters in
One Group and the Other Two Letters in ANY OTHER Two Groups for
example or whatever. I want to have the different Groups ( A,F,K,O,S,W
etc ) Hard Coded in the Macro and Exclude combinations that do NOT
meet the Criteria.

I have Re-Posted this because I have found that Google has been
playing up over the last couple of days.

A Very Big Thanks in Advance.
Paul

Has anyone had a chance to have a look at this and come up with a solution.
All the Best
Paul



(Paul Black) wrote in message m...
Hi Everyone,

I will try and explain simply what I would like to achieve.
I have a Macro that produces combinations ( it produces them in memory
and then inserts them into the Active Sheet ). I ONLY want
Combinations ( with 6 Letters in each combination ) that appear in ANY
Two Groups as Per the Grid ( the Grid Structure could possibly change
) below :-

Example Grid :-
Group 1 - A,F,K,O,S,W
Group 2 - B,G,L,P,T,X
Group 3 - C,H,M,Q,U,Y
Group 4 - D,I,N,R,V,Z
Group 5 - E,J

So A,K,W,P,M,Q and K,S,B,X,D,I would be EXCLUDED. In addition I would
also like to be able to, instead of having ALL Six Letters in ONLY ANY
Two Groups, maybe have the Option to put the Scenario - 4 Letters in
One Group and the Other Two Letters in ANY OTHER Two Groups for
example or whatever. I want to have the different Groups ( A,F,K,O,S,W
etc ) Hard Coded in the Macro and Exclude combinations that do NOT
meet the Criteria.

I have Re-Posted this because I have found that Google has been
playing up over the last couple of days.

A Very Big Thanks in Advance.
Paul

Does anyone know of any links that will point me in the right
direction so I can achieve my goal.

Thanks in Advance
Paul



(Paul Black) wrote in message m...
Has anyone had a chance to have a look at this and come up with a solution.
All the Best
Paul



(Paul Black) wrote in message m...
Hi Everyone,

I will try and explain simply what I would like to achieve.
I have a Macro that produces combinations ( it produces them in memory
and then inserts them into the Active Sheet ). I ONLY want
Combinations ( with 6 Letters in each combination ) that appear in ANY
Two Groups as Per the Grid ( the Grid Structure could possibly change
) below :-

Example Grid :-
Group 1 - A,F,K,O,S,W
Group 2 - B,G,L,P,T,X
Group 3 - C,H,M,Q,U,Y
Group 4 - D,I,N,R,V,Z
Group 5 - E,J

So A,K,W,P,M,Q and K,S,B,X,D,I would be EXCLUDED. In addition I would
also like to be able to, instead of having ALL Six Letters in ONLY ANY
Two Groups, maybe have the Option to put the Scenario - 4 Letters in
One Group and the Other Two Letters in ANY OTHER Two Groups for
example or whatever. I want to have the different Groups ( A,F,K,O,S,W
etc ) Hard Coded in the Macro and Exclude combinations that do NOT
meet the Criteria.

I have Re-Posted this because I have found that Google has been
playing up over the last couple of days.

A Very Big Thanks in Advance.
Paul