looping macro to reformat data from one sheet to another

**johngombola** · 03-17-2009, 05:02 PM

Hi: I'm using Excel 2003, version 11 and am trying to reformat data from one sheet to another. What I would like to do is copy the rows for each team from the Input sheet (Input tab) and and use them to build rows on the Output sheet (Output tab) for each possible combination of players.

In my attached example, a three person team has three combinations and a five player team has ten combinations and so on. I know this is probably a loop within a loop but I can't seem to get the right combination. Not all teams are full yet so the number of players on a team will vary. I need macro code to make the input sheet look the output sheet.

Any help is appreciated.

The attached file does not contain macro code.

John

**rylo** · 03-18-2009, 01:06 AM

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

**johngombola** · 03-18-2009, 11:37 AM

rylo: Thanks for your speedy response. I copied your solution into the spreadsheet I submitted to the excelforum as macro "aaa" and got the following error message from VB: "Run time erro 1004. Unable to get the match property of the worksheet function class." I'm stumped.

Does this suggest anything to you? I've not seen this particular error nor have I used the New Collection before. I recheck the code to make sure I pasted correctly and read up on the collection object. If the error message suggests something to you, send a note along.

Thanks,
John