Copy multiple worksheet into one colum

[sam81]

I have multiple worksheets about 51 that has so many different number of rows
in each sheet that I want to copy the first 4 colums and paste them into a
new worksheet, but not side by side I would like to stack all copied rows and
columns on top of each other in the new worksheet. for example:


In the first worksheet I have. "second worksheet " "third
worksheet" And so on
A B C D A B C D A
B C D
1 2 3 4 5 6 7 8
9 10 11 12
. .

 

[Peo Sjoblom]

Oops! I forgot to paste the link



http://www.rondebruin.nl/copy2.htm

--
Regards,

Peo Sjoblom

What would be the VBA code for this one?

You would need VBA for that

I have multiple worksheets about 51 that has so many different number of
rows

[quoted text clipped - 11 lines]

9 10 11 12
. .

 

[sam81]

thanks for advice, but i get an Compile error that highlights Lastrow saying
"sub or function not defined"

Oops! I forgot to paste the link

http://www.rondebruin.nl/copy2.htm

What would be the VBA code for this one?

[quoted text clipped - 5 lines]

 

[Dave Peterson]

You didn't copy those functions at the bottom of that web page.

thanks for advice, but i get an Compile error that highlights Lastrow saying
"sub or function not defined"

Oops! I forgot to paste the link

http://www.rondebruin.nl/copy2.htm

What would be the VBA code for this one?

[quoted text clipped - 5 lines]

9 10 11 12
. .

 

[sam81]

Thank you so much. It saved a lot of my time.

You didn't copy those functions at the bottom of that web page.

thanks for advice, but i get an Compile error that highlights Lastrow saying
"sub or function not defined"

[quoted text clipped - 8 lines]