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