Search Rows and Copy Based on certain string?
Can someone assist me with the below? I have aExcel 2010 and sheet that has the following data:
First Name | Last Name | Email | Role
There are around 10,000 rows. Essentially I want to make excel search the 'Role' Column and everytime it finds the following pre-defined cases 'business development' ' bus. dev' 'Business Development' ' Business Dev. 'sales' ' Sales' it should copy the full row to a separate sheet? It essentially is a filter but the inbuilt filter for Excel 2010 doesn't seem to allow me to filter on multiple criteria?
Thanks
Should there be a separate sheet for each word? Or all in one sheet?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
All in one sheet, so I should get a second sheet with like 800 rows in it in the same format as the source sheet?
This is a duplicate post, please don't do that as it clutters things up.
Click the * below to say thanks
Girls sleep with guys who use photoshop, but marry the ones who work with Excel
Corduroy pillows: They're making headlines!
Did you mean: recursion
http://www.google.com/search?hl=en&q=recursion
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks