Find matching text and copy all rows to new sheet
Hello,
I am looking for a macro that would Look in column C for the same text (text is not always grouped together) and copy all rows to a new sheet (or if possible a new workbook) and renaming it to match found name.
Final result would be 3 new sheet added.
Capture.PNG
Thanks!
Last edited by Gazou; 09-13-2019 at 08:38 AM.
here is a good example: https://social.msdn.microsoft.com/Fo...forum=exceldev
Click the * to say thanks.
Should works:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Untested, but if I am not mistaken, I think you can compact your code slightly by replacing the first two code lines highlighted in red above with this...Originally Posted by KOKOSEK
and the second two code lines highlighted in red above with this...Please Login or Register to view this content.
Please Login or Register to view this content.
Hello, your code works but would need manual attention if we add a new column of data.
For example,
Please Login or Register to view this content.
Sure you can. I am not trying too much optimize code for transparency purposes.
In the case when OP wants to tweak something is much easier to understand.
@Gazou:
Should works with additional column (not tested)
Instead of:
putPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by KOKOSEK; 09-12-2019 at 11:25 AM.
Great that worked! any clue if and how we could remove the Section so i dont have to add Specific values? so if someone decides to rename a cell it still works?
Thanks for you're help!Please Login or Register to view this content.
Almost have it
What do you mean by 'rename a cell'?
Never mind it worked!
Thank you!
Eric
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks