LinkBack URL
About LinkBacks
I need to extract entire rows from a long list I have, but only extract the rows in which Column A contains a spesific word.
I have attached an Excel sheet with an example of the data I'm working with.
I need to extract entire rows from a long list I have, but only extract the rows in which Column A contains a spesific word.
I have attached an Excel sheet with an example of the data I'm working with.
Last edited by Test123Test; 04-29-2013 at 04:10 AM.
Function ,vlookup() or index(match()) can do that.
If know where to extract, can do a formula for you
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Hi, Test123Test,
apply headers to the range and use Autofilter (or Advanced Filter where criteria range and tagret lie on a new sheet, should be started from there).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Could you upload some examples, thanks
Please take a look at OP attached xlsx file, maybe you can use it as templateOriginally Posted by wenqq3
Function ,vlookup() or index(match()) can do that.
If know where to extract, can do a formula for you
Oops, i no notice your row have same criteria. Perhaps "Filter" is easier way to find it out.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks