LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Copy multiple worksheet into one colum

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.
A B C D
1 2 3 4
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy multiple worksheet into one colum sam81 Excel Discussion (Misc queries) 6 July 12th 07 02:03 AM
copy a formula down the colum and advance it by row only ShoDan Excel Worksheet Functions 4 February 15th 07 05:56 PM
how do I copy multiple column widths from a worksheet in one work. Lockport Excel Discussion (Misc queries) 2 August 2nd 06 09:40 PM
how i can copy colum and pest it in row? Jam Excel Discussion (Misc queries) 1 May 7th 06 09:30 AM
How do I edit a worksheet and copy to multiple files? artex Excel Discussion (Misc queries) 0 August 31st 05 11:08 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"