Hello Friend,
I need to extract the particular data from grouped data's and which extracting data need to arrange another sheet.
Here i mentioned some data's what i want.....
[pre]
[/pre]
Please help me to get the data using macros as i mentioned above.
Thank with regards,
Sampath.S
I need to extract the particular data from grouped data's and which extracting data need to arrange another sheet.
Here i mentioned some data's what i want.....
[pre]
Code:
Input (Sheet 1)
A B C D
1 RT5005 - R RT5005 - R - RM RT5005 - R - RM-ST-MAN RT5005 - R - ST
Output (Sheet 2)
A B C
1
2 RM
3 RM-ST-MAN
4 ST
Please help me to get the data using macros as i mentioned above.
Thank with regards,
Sampath.S