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

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

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

.. if data are entered in A1:A300 and B1:B300
(they need go together)

Assume the above is made in Sheet1 as before

In Sheet1,

Put in C1: =TRIM(A1&" "&B1)
Copy down to C300

In Sheet2, change the reference to point to Sheet1's col C instead of col A,
i.e.

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

Copy A1 across and fill down to E60 as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Chi" wrote in message
...
Thanks Max, I got it. It is wonderful!

For another case that if data are entered in A1:A300 and B1:B300 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

Hi Max,
Again, excellent!

There is a small thing that I need help in this question. Please.
It returns to my designed outputs. Great! However, the data of combined
field (c)appear very close. I would like to make them separately.

Ex: A B
C
Department 1000 then it becomes
Department 1000
Education 200
Education200
Test 5
Test5
I wish they could show like the format below.

Department 1000
Education 200
Test 5

Please help.

Thank you so much!
Chi

"Max" wrote:

.. if data are entered in A1:A300 and B1:B300
(they need go together)

Assume the above is made in Sheet1 as before

In Sheet1,

Put in C1: =TRIM(A1&" "&B1)
Copy down to C300

In Sheet2, change the reference to point to Sheet1's col C instead of col A,
i.e.

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

Copy A1 across and fill down to E60 as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Chi" wrote in message
...
Thanks Max, I got it. It is wonderful!

For another case that if data are entered in A1:A300 and B1:B300 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

My last post is mess . Please read this post. Thanks.
Chi
-------------
There is a small thing that I need help in this question. Please.
It returns to my designed outputs. Great! However, the data of combined
field (c)appear very closely. I would like to make them separately.

Ex: A B C

Department 1000 Department1000
Education 200 Education200

I wish they could show like the format below.( Department is at left align and 1000 is at right align)

Department 1000
Education 200
Test 5



Please help.

Thank you so much!
Chi

"Max" wrote:

.. if data are entered in A1:A300 and B1:B300
(they need go together)

Assume the above is made in Sheet1 as before

In Sheet1,

Put in C1: =TRIM(A1&" "&B1)
Copy down to C300

In Sheet2, change the reference to point to Sheet1's col C instead of col A,
i.e.

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

Copy A1 across and fill down to E60 as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Chi" wrote in message
...
Thanks Max, I got it. It is wonderful!

For another case that if data are entered in A1:A300 and B1:B300 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