[INDENT]Guys i find it hard to do this is macro.im a newbie in vb.
anyone can help.
below is my sampe datasheet.Col.A & B.
A B
1 A
2 A1
2 A2
3 A2.1
2 A3
3 A3.1
1 B
2 B1
2 B2
3 B2.1
2 B3
i want to result like below format in Col.C & D.
C D
A A1
A A2
A2 A2.1
A A3
A3 A3.1
B B1
B B2
B2 B2.1
B B3
//* note
* 1 is the parent node of 2
* 2 is the parent node of 3
* 3 is the parent node of 4
and so on...
Appreciate your help.
Regards,
S5 [/INDENT]