You could use Autofilter.
Assuming you have labels in row 1 to correspond with the information posted,
1. highlight A1:G1
2. DataFilterAutofilter
3. Click the dropdown in G1 and select Custom
4. Scroll the left pane to select "is greater than"
5. Enter 25 in the right hand pane

You will now have a table with visible rows only being those with a value of
greater than 25 depth.
NB if you want to include 25 in your sample, then either choose "is greater
than or equal to" or leave it as "is greter than" but set the value to be 24

--
Regards
Roger Govier
"rhani111" wrote in
message ...

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