Macro to do same series of commands but dynamically

[ccmulder]

Okay so this should be easy for someone who knows the commands. What I have is this:

A long list of data all of which is 26 rows long then repeats another series. What I am trying to do is copy 25 rows starting with the second row and transposing that to the first row, column B.

So what I have is Name1, then 25 rows of data under that, and then Name2 and 25 rows of data under that and so on through Row 1586--soe through "Name61" with 25 rows of data under each name

So for example starting at Cell A1, Name1. Then from A2 to A26 are the first 25 rows of data. I want to copy what's in A2 to A26 and transpose it starting with Cell B1 so that data will then extend from B1 to Z1.

Next, I want to delete rows A2 to A26. This will move the next series of data to Cells A2 to A27 and repeat the process but this time I want "Name2" in A2 and the 25 rows of data and the transpose the 25 rows of data to Cells B2 to Z2 and so on.

So when its done I should have 61 rows (Name1 through Name 61) each with 25 adjacent columns of data.

So when I try to write a macro OF COURSE the macros uses static ranges and I need it to be dynamic. This can be done with a macro that does the whole thing at once OR does one set of data and I have to run it 61 times obviously all at once is preferable.

I have attached the file--essentially these are the coaches rankings for the College Football playoffs each coach ranking teams 1 through 25. I attached a second copy with the first two rows done to see how it should be done. And preferably I would like the columns to be only a bit larger than the largest item in that column.

Chris.

[AlphaFrog]

Please Login or Register  to view this content.