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