i have a data that looks like this
A B C D E F G H I J K L M N O P...........AF
aa aa aa aa bb aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa ccmnyd aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa ddjkd aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa ejklaaa aa aa aa aa aa aa aa aa aa aa aa...........
.
.
.
.
like up to 80,000 files
and solution has to be like this....
A B C D o E F G H I J K L M N O P...........AF
aa aa aa aa 1 b aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 2 b aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 1 c aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 2 c aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 3 m aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 4 n aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 5 y aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 6 d aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 1 d aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 2 d aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 3 j aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 4 k aa aa aa aa aa aa aa aa aa aa aa...........
aa aa aa aa 5 d aa aa aa aa aa aa aa aa aa aa aa...........
Actually, all the "aa" i mentioned are not the same data they are of different values. so anyone please tell me the macro for this so that i can save some time and i am new to vb so please help me,
one more thing is i tried some code and i could split the data but i could get the numbering because every record has different number of rows, so i could not give the numbering based on how many rows it has split to...............
please help me...........
Thank you all......
Bookmarks