Hi Guys,

I am new, here and i really need some help.

I have a table with 4 columns. I need to check the last column for values
greater than 0. Then display all of the rows for those cases, and ignore the
cases where the value in the column is 0.

7 5 6 7
1 3 3 4
3 2 1 0
5 6 7 9


so in the above example, it would display everything except; 3 2 1 0,
because 0 is not 0.


I need it to be on a seperate sheet from the one that my tables are on. So
that i can click on it and the 'filtered' data is there ready for print.


I have tried the auto filter function, but that is not what i am looking for.

I have been playing with the following =IF(I10,K1,'data'!A4) types of
formula but without success.

Thanks Guys!!!!