I desperately need help with creating a function, macro or anything that
you guys can think of to make things easier!!

I have a range of cells that list different information that I need to
bring together into another table. This has been easy enough, BUT I
need the data to skip zero or blank rows and only list information that
is greater than a certain number.

For example
Column A is an ID number
Column B is the location
Column C is the date
Column D is the total tonnes
Column E is the number of Days
Column F is the Actual rate
Column G is the depth

What i want the table to reflect is ONLY the rows that have a figure
greater than 25 in the Depth or Column G.

This i have managed quite well, but I don't want rows that are blank or
zero in the new table...any ideas????

A macro would be fine here too.....but i would prefer a function????


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=386046