Hi ,
I have an excel file which has 12,000 rows and about 50 columns. There are cells with vales "MISSING" and "MISMATCH". My goal is to find the cells with these values and copy the corresponding row and one row above i.e if " i is the corresponding row that contains the values, then i need to copy i-1 row as well ith row to a new sheet in the same workbook"

I have tried many macros. Maximum i can do is find the rows with the values above! PLz help me out with a macro for this!!