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