Macro for List Cut - Paste and Repeat

I have looked through prior threads but cannont find my issue...
I have a long list of 2 column data...


Every nth row I wish to cut x cells and paste y cells up and over, then delete the rows where the data came from.. See Example Below.. this should loop until there are blank cells. Any help is appreciated



M Cowe
L Cow
M Cox
P Cox
S Cox
C Clark

to

M Cowe P Cox
L Cow M Cox
M Cox C Clark

Give this macro a try:

Please Login or Register  to view this content.

Thank you for the reply. I have been trying to modify the code, however having difficulty so I will try to explain exactally what i need....
I Have two columns of data In
Column A Column B
Rows 1-100

And lets assume there is 20 rows per page

Lets say after 20 rows of data (1-20) I need the next 20 rows to be placed into Column F and Column G (rows 21 - 40)

Then then rows 21 - 40 to be deleted and the process start over so there will be 5 pages, consisting of 4 colums of data.


Thank you again for your assistance.

Let's not assume anything. When you ask a question as specific as your first, you get a specific macro. If your need is actually DIFFERENT, that's just more unnecessary work.

Ok, 20 rows at a time?

Please Login or Register  to view this content.

Ok, another shot. 100 rows doesn't parse into sets of 40, so I adjusted it to sets of 20 (10 paired sets of data moved to new column at a time.)

This macro at least shows you another way to delete the blanks.

Please Login or Register  to view this content.

Originally Posted by slx

I'll give it a shot

[code]

Hehe, nope, but that was fun to watch...looked snakes pulling data around the sheet.