I have a worksheet within a large spreadsheet that produces a large range of data in rows. One of the columns in this worksheet may produce a zero (in a specific, unvarying, column). When a zero appears in that column (let us say Column P) I want every row that contains this zero in column P, to be suppressed - to disappear, leaving no blank row.
Thus, although there may be 300 rows, it could be that on occasions I will end up with just 20 rows, because 270 of the rows have a zero at Column P. I need to say that not all the rows are identical - some of the rows have cells that have been merged to make headings, etc - so some of the rows don't have a Column P.
Hope that all makes sense.
I do not really want to put the spreadsheet on this site, for commercial reasons, but if need be I could write a little representative sample of what I'm talking about: but I think I've made it reasonably clear what I'm trying to achieve.