View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Y. Belenky Y. Belenky is offline
external usenet poster
 
Posts: 4
Default Data sorting macro

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.