dear all,
i currently facing a problem using VBA as i am new to it.

i had in sreadsheet which look like this:

ID Descrp
KAS_1 123
KAS_2 345
TSK_2 456
TSK_3 567

i wish to write a macro which can generate the output txt like this:

KAS.txt
-------
1=123
2=345

TSK.txt
-------
2=456
3=567

In short, if the left 3 characters are the same, i wish to put those info together under one txt file.

Anyone can help on this?