Hiding rows if specific cell does not contain key word

J

jermsalerms

I am trying to hide rows 127 - 216 on sheet2 if cell J13 on sheet1 does
not say "Combo"

I need to do this because all the data in this area only shows up if
"combo" is selected and when I print a report pages 4 and 5 are blank.
And the reports are converted to PDF so I have 10 pages and the middle
ones are blank. It just doesnt look good.

Any suggestions.
 
G

ginetta

Try using a tracking column. This column can have an If statement which
will translate
to a 0 or 1 based on whether there is information on said page.
Then filter the tracking column to only show 1.

If you have sections such as paragraphs or pages reference every row in
that range to
the initial IF statement for that range. This will then have all the
rows in each range as either 1 or 0

When you filter only the ranges with 1 will ever appear and print.
Place the tracking column outside your print area and it will never
show up on the printed document.

It's a cheap trick but it works for me.

Example:

from rows 127-216
tracking column
=IF('sheet1'!$J$13="Combo","1","0")
place that in each row 127-216 in a column outside printable area.

Then just filter.

Obviously you will have to place a 1 in all other rows being filtered
to include them
in the filter results.


G.
 
Top