Given that sheet1 has a table of values, sheet2 can have a similar
table, but with formulae. Every cell in sheet2 corresponds to the same
cell in sheet1, so sheet2 D6 holds the formula relating to sheet1 D6.
As an example, column C is the column stating "ok" or "not ok". For
sheet2 A1, use this:

=IF(Sheet1!$C1="not ok",Sheet1!A1,"")
Drag this to the bottom of the table.

Sheet2 now only shows the rows with "not ok" in column C. The problem
is you'll find loads of empty rows. To shorten this, highlight the
entire table and sort it by any column you wish in descending order,
this will group all "ok" (invisible rows) together at the bottom of the
table.


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=476166