Taking content of columns and returning in new sheets

[dguenther]

Hello,
What I need to do is very akin to the following post: Mr. Excel Forum Post
But there are a couple little twists.

I’ve got the following scenario:A sheet (Sheet1) with some columns that look like this:[TABLE="width: 256"]
<tbody>[TR]
[TD]Billy[/TD]
[TD]Bobby[/TD]
[TD]Sally[/TD]
[TD]Joe[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]

I have a second sheet (Sheet 2) that looks like this:[TABLE="width: 780"]
<tbody>[TR]
[TD]Totals[/TD]
[TD]Billy[/TD]
[TD]Bobby[/TD]
[TD]Combined[/TD]
[TD]Billy Score[/TD]
[TD]Bobby Score[/TD]
[TD]Billy Cumul Score[/TD]
[TD]Bobby Cumul Score[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]CC[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]CC[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]DC[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]11[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]CD[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]CC[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]14[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]CC[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]17[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]CC[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]DC[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]25[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]-blank-[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]CD[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]25[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

Columns 4 through 8 are automatically populated via formulas I’ve created, after Columns 2 and 3 are filled.
What I would like is a macro that does the following:

1. Copy the data from the first column ('Billy') in Sheet 1 and put it into the second column of Sheet 2
2. Copy the data from the second column in Sheet 1 ('Bobby') and put it into the third column of Sheet
3. Now my formulas will populate the other columns.
4. Take these “results”, all of the info currently in Sheet 2, and then paste (values only) them into a new sheet called “[Sheet1.B1] x [Sheet1.C1]” in this example, it would be “Billy x Bobby”4. Repeat with every combination of non-duplicated column match-ups (every column gets matched with every column once, and once only):

• a. Billy x Bobby
• b. Billy x Sally
• c. Billy x Joe
• d. Bobby x Sally
• e. Bobby x Joe
• f. Sally x Joe

So, in the end there would be a workbook with 8 sheets. I very much appreciate any suggestions or help.

Best,DG

 

[dguenther]

Anyone with any thoughts?