Copy Data from row to multiple rows

[rloser]

http://www.excelforum.com/images/smilies/confused.gif

I am new to Excel/VBA. Copy data from Column A. Taking one instance, copying multiple times into another row. Then step down one row, copy that data the same number of times, then after so many instances. Start copying into another column. Here is an example of what I am trying to accomplish.

1. Count number of rows in column A with data.
2. Start loop from A2 to End of Column A
3. Copy A2 to B2:B7
4. Copy A3 to B8:B13
5. Copy A4 to B14:B19
6. Copy A5 to D2:D7
7. Copy A6 to D8:D13
8. Copy A7 to D14:D19
9. Continue the loop until last row of column A has been copied.

Any help would be appreciated. http://www.excelforum.com/images/smilies/smile.gif

[rylo]

Hi

How about this

Please Login or Register  to view this content.

rylo