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
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750

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!$H40.01,Names!$A4,)

to

=IF(Names!$H40.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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750

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.
--
Gary's Student


"superkopite" wrote:


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
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750

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



"superkopite" wrote
in message ...

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
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750

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!!!!


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503750