Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

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

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1