Restrict rows

Hello lovely forum people,

I would like to be able to limit the amount of rows that can be pasted in to a column then carry over the remainder to the next column and so on.

Example: I have 100 rows to paste into a sheet. I would like to limit the amount of rows to 30.
What I would like to happen is I paste my 100 rows of text into column A and I end up with 30 rows in column A B and C and 10 rows in column D.

Many Thanks
Paul

Pierre,

You have revolutionised my working life. Saved me many many hours of monotonous copy and paste.

Merci beaucoup
Paul Hyland

Hi Pierre (macro guru),

Is there a way to do the opposite?

I would like to take many columns with varying amounts of rows and put them all into one column.

Example: Column B has 10 rows of text Column C has 5 rows of text and Column D has 15 rows of text.
What I would like to happen is: I select columns B, C, and D, press the magic button and they all go in to column A.
B followed by C followed by D and so on.

So Colunm A would end up with with 30 rows, B followed by C followed by D and so on.


Many thanks
Paul