|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2004, 11:09 PM
|
|||
|
|||
Copying a column from several similar sheets into one sheet
I have several worksheets in one workbook and I want to merge/copy one
column from each worksheet (the same column) (Like this, just imagine more columns with more data on several worksheets Date 06052003 Actual 13 FMT 12 % 87 ) and put these columns into rows so that each worksheet's data will descend vertically (EX: Date Actual FMT % 06052003 13 12 87 06062003 12 15 89 06072003 11 17 90 That's what I want, Please help me to do it. 
|
|
#2
June 16th, 2004, 04:57 AM
|
|||
|
|||
|
Copying a column from several similar sheets into one sheet
Why don't you record a macro and post it? Then I'm sure someone can help you
tro streamline the code. To paste the columns in row format, use Edit | Paste Special | Transpose. -- Vasant "Lost" wrote in message om... I have several worksheets in one workbook and I want to merge/copy one column from each worksheet (the same column) (Like this, just imagine more columns with more data on several worksheets Date 06052003 Actual 13 FMT 12 % 87 ) and put these columns into rows so that each worksheet's data will descend vertically (EX: Date Actual FMT % 06052003 13 12 87 06062003 12 15 89 06072003 11 17 90 That's what I want, Please help me to do it.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
