Copy Between Sheets Based on Condition

[london735]

Hi!
I ask you to help me to complete this project. I have done all tasks that could be done with formulas alone and now I need a macro to finish the calculation. Let me briefly describe the purpose of this project. The aim is to find number combinations in different columns that occur the most times next to ones in the Gain column and also occur the least times next to the zeroes in the Gain column. This is already done for one single pair of columns on the Results tab. You have to manually change the column names in the red-colored cells on the Results tab. I have listed all possible column combinations on the Pairs tab. Now, I need a macro which will copy these column combinations to the I2 J2 cells. After each copy operation the Count, Gain and Rank columns will update. I need the macro to search the Rank column and find those rows with Rank greater than 0 (these can be called hits). If there are any hits, a heading should be appended to the new Output tab which will show the current column combination which is being analyzed. After this heading all hits should be copied. A hit record should include the corresponding values from the First, Second, Count and the Rank columns.
Here is an example of how this macro output would look for the first 3 column combinations:
A B
2 5 1 1 1
5 4 5 3 1
5 8 1 1 1
6 8 1 1 1
8 7 25 13 1
A C
2 1 1 1 1
5 1 1 1 1
5 6 9 5 1
5 7 3 2 1
6 2 1 1 1
7 10 2 2 2
8 8 13 9 5
8 9 10 6 2
A D
2 1 1 1 1
5 7 8 5 2
5 8 3 2 1
6 1 1 1 1
7 10 3 3 3
8 4 1 1 1
8 8 10 6 2
8 9 9 6 3

From the above 3 pairs there is instantly apparent 8,8 sweet combination for the A C combination which has the Rank of 5!.

Please tell me that such a macro is not impossible to do!)
Looking forward to hear what you think

[valerij]

Проверим свои переводчики?
Мой:
Копируйте Между Листами Основал на Условии

Привет!
Я прошу вас помочь мне, чтобы завершить этот проект. Я сделал все задачи, которые могли быть сделаны с формулами только и сейчас мне нужна макрокоманда, чтобы закончить вычисление. Позвольте мне кратко описывают цель этого проекта. Цель - найти комбинации номера в различных колонках, которые происходят больше всего времен рядом с теми в колонке Выгоды а также происходят наименьшие времена рядом с нолями в колонке Выгоды. Это уже делается для одной единственной пары колонок на таблице Результатов. Вы имеете вручную
------------------------------------------------------------------------
От выше 3 пар там мгновенно очевиден 8,8 сладкой комбинации для комбинация C, которая имеет Разряд 5!. Скажите мне, что такая макрокоманда не невозможна сделать!) Надеясь на слышать, что вы думаете

[IgorGO]

Look at this

[london735]

thank you IgorGo!
That was very elegant solution but I have to say that it is still incomplete because I am going to use huge number of different-length column combinations. Those that are shown on the pairs are just examples. For example here is a subset of the 5-member combinations of a 11-letter series (the whole number of 5-member combination of the 11-letter set is 462, so there wont be enough columns for this):
A B C D E
A B C D F
A B C D G
A B C D H
A B C D I
A B C D J
A B C D K
A B C E F
A B C E G
A B C E H
For I need a macro which will simply copy 2-member pairs from the pairs tab to thec ontrolling cells on the results tab. Later I would modify this macro to copy 3,4, or 5 letter combinations.

Thanks again and looking forward to hear what you think!

[IgorGO]

If to take 3 letters - will get 1000 records, 5 letters - 100 000 records. It is a table of Excel more than!
Decisions of the this task is not here.