0 or greater. :help please

[Stuart Arnold]

I have a spreadsheet with several pages, on last page have rows with formula's reading data from previous pages. Data could be 0 or greater.
Is there a way of compressing rows(useing macro or other means) to only see rows with value 1 & above.
At the moment i have row with data, 2 blank rows (with formula) then row with data then blank etc etc. Depending on data entered on first pages the results on last page can be different every time, the blank rows with formula's can be in a different position. I only want to print rows with data. It needs to print in the order on the page. I have recorded a macro which deletes blank rows but it leaves ones with formulas in..even if result value is zero. Is there anywhey of getting rid of these..

[intruder9]

Can't you use auto filter and use a custom filter of greater than 0