Non printing rows

[superkopite]

Hiya Guys and gals

could someone please help me out

i have 200 rows, in all rows there is somekind of forumla. what i want
to do is only print the rows that have had data entered into them

Is this possible or am i living in dreamland

cheers
James

 

[superkopite]

One way that i can see being able to do this and would probably be a
prefered option would be to change the following formula;

=IF(Names!$H4>0.01,Names!$A4,)

to

=IF(Names!$H4>0.01,Names!$A4,HIDEROW)

Obviously it will not work with HIDEROW written it it but is it
possible to stipulate that if the result is false it would hide that
row?

Cheers

James

 

[Gary''s Student]

Temporarily hide rows without data:


1. in IV1 put a label

2. in IV2 enter:
=COUNTIF(A2:IU2, "") and copy down
cells showing 255 represent empty rows

3. select IV1 and pull-down:
Data > Filter > Autofilter

4. go back to IV1 and click the dropdown and select (Custom...)
drop-down and select does not equal
and enter 255 in the next field


The empty rows will be hidden and will not print. You can use variations of
this to hide rows based upon lots of criteria.

 

[JMay]

How bout the use of (applying the) Data, Auto-Filter and
then filter on yourfield <> 0 or <> "" or the like?

 

[superkopite]

Thanks guys i just worked out how to use the autofiler, i even managed
to attach a macro to it so all i have to do is use a Ctrl+U keypress.

Man i love this program more than my family!!!!