Data sorting macro

[Y. Belenky]

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.

 

[David McRitchie]

HI Yuri,
Not quite clear on what you want to do.
It would appear that you want the original column A
and then the sorted results split to the other columns
with 100 items in each column.

Take a look at my page for help with snaking column A
to separate columns. The example will create a new
worksheet with columns A through whatever limited to
whatever you specifiy as the limit. Headings can be
retained for each column.
SNAKECOLS, How to snake columns to use fewer pages
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Y. Belenky]

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

 

[David McRitchie]

Hi Yuri,
Always great to get feedback, especially when it is not
clear if the answer is on target as was the case here.

Another situation where feedback is important is where several different
answers were provided -- it is always good to hear which choice was
chosen for implementation and why.