• 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.

request for help on splitting text using VBA in excel

mohanyathish

New Member
I have some data in excel in the form below:


Col1 Col2 Col3

Test Name Other

Test Name Other

Test Name Other

Test1 Name Other

Test1 Name Other

Test1 Name Other

Test2 Name Other

Test2 Name Other

Test3 Name Other

Test3 Name Other


I want all rows with similar first column value in a new worksheet in the same workbook


Thanks for help in advance
 
Hi Mohan...


Thanks for your post and welcome to Chandoo.org forums.


Please see this page to understand how to split your data.


http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
 
Back
Top