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