• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macros for Data Extracting from grouped data's

sampath

Member
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]
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
[/pre]
Please help me to get the data using macros as i mentioned above.


Thank with regards,

Sampath.S
 
Based on your example, I'm making the assumption that the method is:

Take the text from col A. Subtract this from whatever is in the other columns, and also remove the "-" mark.


However, I'm not sure how you want to handle having multiple rows on Sheet 1. Where do they all get outputted to on Sheet 2?
 
Back
Top