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