Hi everyone,

I have a list of 3160 "Pairs". e.g. 1,2 1,3 up to the last pair 79,80

This list is located in cell range EE1 through EF3160o, worksheet "Draws"

What I would like to know if this is possible:

1. Copy the 1st "Pair" 1 and 2 (cell EE1 & EF1) to the same worksheet "Draws" cell AD3:AE3

2. Copy the information from cell range AF3:AG3 to another worksheet "Pairs".

Then next pair 1,3:

1. Copy the 2nd "Pair" 1 and 3 (cell EE2 & EF2) to the same worksheet "Draws" cell AD3:AE3

2. Copy the information from cell range AF4:AG4 to another worksheet "Pairs".

Continue this process until the very last pair 79,80 which is a total of 3,160 "Pairs" are calculated.

Thanks in advance!!

I have a list of 3160 "Pairs". e.g. 1,2 1,3 up to the last pair 79,80

This list is located in cell range EE1 through EF3160o, worksheet "Draws"

What I would like to know if this is possible:

1. Copy the 1st "Pair" 1 and 2 (cell EE1 & EF1) to the same worksheet "Draws" cell AD3:AE3

2. Copy the information from cell range AF3:AG3 to another worksheet "Pairs".

Then next pair 1,3:

1. Copy the 2nd "Pair" 1 and 3 (cell EE2 & EF2) to the same worksheet "Draws" cell AD3:AE3

2. Copy the information from cell range AF4:AG4 to another worksheet "Pairs".

Continue this process until the very last pair 79,80 which is a total of 3,160 "Pairs" are calculated.

Thanks in advance!!

Last edited: