Hi ALL,

I've data file stored in text (ASCII) format. The data
are numbers sorted in one column. After opening in Excel
I would like to sort them by small packets in the rows,
for example cells from A1 to A100 move to B1...B100,
from A101 to A200 move to C1...C100 etc.
Is there any template macro available? Maybe someone
can help me with writing such macro.

Thanks,
Yuri.

See reply in excel.worksheet.functions where you also posted.


"Y. Belenky" wrote in message ...
Hi ALL,

I've data file stored in text (ASCII) format. The data
are numbers sorted in one column. After opening in Excel
I would like to sort them by small packets in the rows,
for example cells from A1 to A100 move to B1...B100,
from A101 to A200 move to C1...C100 etc.
Is there any template macro available? Maybe someone
can help me with writing such macro.

Thanks,
Yuri.

Hi David,
This is exactly what I looking for.
Thank you very much.
Yuri.


David McRitchie wrote:

See reply in excel.worksheet.functions where you also posted.


"Y. Belenky" wrote in message ...

Hi ALL,

I've data file stored in text (ASCII) format. The data
are numbers sorted in one column. After opening in Excel
I would like to sort them by small packets in the rows,
for example cells from A1 to A100 move to B1...B100,
from A101 to A200 move to C1...C100 etc.
Is there any template macro available? Maybe someone
can help me with writing such macro.

Thanks,
Yuri.