VBA for searching string in a column and copy rows depending on string in adjacent cell
I am completely new for VBA. I have excel data sheet containing numbers and strings. I want to search for certain string say 'CYP' in column 'I' then look for a cell of its row at column 'C' and copy entire rows containing the string of cell 'C'. I want to paste in sheet 2 of the same workbook and loop it again to look for remaining CYPs in column 'I'. (I have attached a problem file sample with desired result in the attachment.)
Would you help me on this please?
Last edited by xprakash; 10-19-2013 at 10:14 PM.
Hi xprakash,
Welcome the forum!!
Let us know how this goes:
Regards,
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thank you Robert,
The code copied all the rows having CYP in row. It is really great but what I wanted was a step further.
If there is the presence of CYP in any cell of column I, I want it to check a cell of the same row at column C and copy all the rows containing exactly the same string as in that cell to paste on sheet2 and loop this action until the search for cyp at column I reaches to the end of the column.
Any ideas?
So the first matching row in Sheet1 is 2. Do you then want all the matching entries for ADF45 (this is in cell C2) copied to Sheet2. If so, what happens with Row 3 as the code in cell C3 is again ADF45? This will mean that all the cells with ADF45 will in fact be copied 4 times as there's an overall total of 4 matches?
Perhaps if you could post the desired results in a separate tab it will make things clearer.
Robert
Yes, it is exactly what I want.Originally Posted by Trebor76
I want it to look for CYP in column I only after the last row it copied and loop the action as above.
I have attached a file with desired result tab in my original question (thread) above.
Thank you
You didn't answer the second question i.e. what happens when the same title is found in column C
In any case, I think you only want show the title from column C once, so see how this goes:
RobertPlease Login or Register to view this content.
Thank you again Robert. But this macro copied the first row with CYP at column 'I for every row with same string at a cell in column C of same row. Would you modify it testing with the file attached above please?
Yes, by changing this line of code...Thank you again Robert. But this macro copied the first row with CYP at column 'I for every row with same string at a cell in column C of same row. Would you modify it testing with the file attached above please?
...to this:Please Login or Register to view this content.
should do the job.Please Login or Register to view this content.
Regards,
Robert
Wow! Thank you very much Robert. It did a trick
That's great
If you could please mark the thread as solved it would be appreciated.
Regards,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks