Copy & Paste Special entire row from one sheet to another if cell is contains "NOTOK"

[rvkadu1]

I would like to Copy & Paste Special entire row from one sheet to another if cell is contains "NOTOK"

Example
Mch Code Parameter Code 1st Date 2nd Date 1st Month Reading 2nd Month Reading Diff Previous Reading Match
RTG01 HOURS 3/6/2013 15:54 10/6/2013 10:36 44008 44008 0 44008 1
RTG01 HOURS 3/6/2013 9:32 10/6/2013 10:36 44008 44008 0 44008 1
RTG02 HOURS 3/6/2013 13:02 10/6/2013 10:22 43126 43280 154 43122 1
RTG02 HOURS 3/6/2013 8:31 10/6/2013 10:22 43122 43280 158 43122 1
RTG03 HOURS 3/6/2013 8:23 10/6/2013 10:22 44727 44889 162 44727 1
RTG03 HOURS 3/6/2013 12:45 10/6/2013 10:22 44730 44889 159 44727 1
RTG04 HOURS 3/6/2013 10:59 10/6/2013 10:49 45835 45956 121 45834 1
RTG04 HOURS 3/6/2013 9:12 10/6/2013 10:49 45834 45956 122 45834 1
RTG04 HOURS 3/6/2013 9:12 10/6/2013 10:23 45834 45956 122 45834 1
RTG04 HOURS 3/6/2013 10:59 10/6/2013 10:23 45835 45956 121 45834 1
RTG05 HOURS 3/6/2013 12:01 10/6/2013 10:24 41043 41195 152 41041 NOTOK
RTG05 HOURS 3/6/2013 9:04 10/6/2013 11:28 41041 41195 154 41041 NOTOK
RTG05 HOURS 3/6/2013 9:04 10/6/2013 10:24 41041 41195 154 41041 NOTOK
RTG05 HOURS 3/6/2013 12:01 10/6/2013 11:28 41043 41195 152 41041 NOTOK

Result Require

Mch Code Parameter Code 1st Date 2nd Date 1st Month Reading 2nd Month Reading Diff Previous Reading Match
RTG05 HOURS 3/6/2013 12:01 10/6/2013 10:24 41043 41195 152 41041 NOTOK
RTG05 HOURS 3/6/2013 9:04 10/6/2013 11:28 41041 41195 154 41041 NOTOK
RTG05 HOURS 3/6/2013 9:04 10/6/2013 10:24 41041 41195 154 41041 NOTOK
RTG05 HOURS 3/6/2013 12:01 10/6/2013 11:28 41043 41195 152 41041 NOTOK
RTG12 HOURS 3/6/2013 8:26 10/6/2013 9:25 41486 41625 139 41486 NOTOK
RTG12 HOURS 3/6/2013 13:28 10/6/2013 9:25 41490 41625 135 41486 NOTOK
RTG16 HOURS 3/6/2013 8:55 10/6/2013 9:25 44362 44438 76 44362 NOTOK
RTG22 HOURS 3/6/2013 9:40 10/6/2013 10:29 36889 36946 57 36889 NOTOK
RTG26 HOURS 3/6/2013 8:45 10/6/2013 9:27 42434 42560 126 42434 NOTOK

For more details please ref. attached file (with require colours in result resuire sheet)

Please Help me.

RK

[zbor]

Try this macro:

Please Login or Register  to view this content.

[rvkadu1]

Thanks a lot sir for very extreme prompt response, remaining is only colours in this Mch Code-wise , which i describe in attached file
i.e.

bright yellow & bright sky blue colours to identity Mch Code

Please help me Sir.

RK

Try this macro:

Please Login or Register  to view this content.

[zbor]

use this:

Please Login or Register  to view this content.

[rvkadu1]

Thank you Sir, you are really brilliant