Thanks Max, I got it. It is wonderful!

For another case that if data are entered in A1:A300 and B1:B300 (they need
go together)
Ex: A B

Education 2003
Data are entered in A and B columns will stop at row 60 and continue to fill
in D1 and E1 columns and go on....

Please help .
Thanks
Chi


"Max" wrote:

One play is to mimic this as an output on another sheet ..

Assume data will be entered in A1:A300 in Sheet1

In Sheet2,

Put in A1:

=IF(INDIRECT("'Sheet1'!A"&COLUMNS($A$1:A1)*60-60+ROWS($A$1:A1))=0,"",INDIREC
T("'Sheet1'!A"&COLUMNS($A$1:A1)*60-60+ROWS($A$1:A1)))

Copy A1 across to E1, fill down to E60

A1:E60 will return the desired outputs from the inputs in Sheet1's A1:A300
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Chi" wrote in message
...
Hi,
In Word, it has Columns function that is very useful. When the column A is
full in one page, the data automatically go to column B and then C....
-----
In Excel, I would like to create a sheet, which has 5 columns. I hope that
(on column A) after data is entered into row 60, the next data will move
to
column B, not go to the row 61. And then when column B is entered to row
60,
the next data will move to column C....
Please help.
Chi