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.