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
. .

You would need VBA for that


--
Regards,

Peo Sjoblom



"sam81" <u35770@uwe wrote in message news:7508724b3cdf1@uwe...
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
. .

What would be the VBA code for this one?

Peo Sjoblom wrote:
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
. .

Oops! I forgot to paste the link



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

--
Regards,

Peo Sjoblom

"sam81" <u35770@uwe wrote in message news:75088cab4b8f1@uwe...
What would be the VBA code for this one?

Peo Sjoblom wrote:
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
. .

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


Peo Sjoblom wrote:
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
. .

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

sam81 wrote:

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

Peo Sjoblom wrote:
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
. .

--

Dave Peterson

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

Dave Peterson wrote:
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]
9 10 11 12
. .